Create a Calculated Column in a Data Flow

Add a new column in a projection operator and define the expression that will fill it with data.

Procedure

  1. In the properties panel of the projection operator, choose (Add New Calculated Column) in the Columns section.
  2. Provide a name and data type for the column. Additional fields are displayed for the following data types:
    Data Type Additional Field

    string

    (Optional) Length: Define the maximum number of characters that is allowed for the column.

    binary

    (Optional) Length: Define the maximum number of characters that is allowed for the column.

    decimal

    Precision: Define the maximum number of digits (including Scale) that is allowed for a value in the column.

    Scale: Define the maximum number of digits that is allowed after the decimal point for a value in the column.
    For more information, see Data Types from the SAP HANA Cloud SQL Reference Guide.
  3. In the Expression field, define the expression for the calculated column. You can build your expression by choosing from the Functions (see Function Reference for Data Transformation Language), Columns, Input Parameters (see Create an Input Parameter in a Data Flow), and Operators.