Execute Formula

Performs operations on values and inserts the result in a new column.

The content for the column may be a numeric or string constant, the NULL value, an empty string, a row value, or an operation consisting of constants, column references, functions, and operators. Non-string column values are converted to strings in a concatenation. Dates are converted to string values based on the current locale and format of the execution environment.

Step name: Defines the name for a step. Provide a meaningful name so that anyone who edits transformation steps in a pipeline will be able to identify the purpose of a step.; For example, "Add Address column".
Constructor: Accepts a formula in Excel format. The formula may include any or all of the following:
Constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants.

Reference: A column reference. This is consists of the column name enclosed between brackets, such as [Street] or [City].

Operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.

Function: An Excel function such as SUM and CONCAT, that accepts and returns values. These consist of the function name and arguments enclosed between parentheses. Arguments may include numbers, text, column references, and functions. For example CONCAT([Street],", ",[City],", ",[PostalCode]).
Output column: Specifies the name of the output column.
Output Column Datatype: Choose from one of the possible column data types (String, Integer, Long, Float, Double, Boolean, Bigdecimal, Date, Datetime, Time). Numeric values are converted to strings for a string type and strings are converted to numeric values for the numeric types.
Transformation Preview: The Transformation Preview table shows the output column and any columns referenced by the formula in the Constructor box. The table shows an error or is blank when there are errors in the formula or for unsupported conversions to an output data type (such as an for the Integer data type when there alpha-characters "onetwothree" instead of numeric characters "123" in a string value).
Save: Click this button to close settings and save changes to the transformation settings.
Preview: Click this button to preview the results of the transformation settings.
Cancel: Click this button to close settings for this transformations without saving any changes.