XMPro Derived Column – Transformation

Derived Column Transformation allows you to create new columns or replace existing columns of data by applying expressions to the streaming data. This action agent is used when you want to apply arithmetic operations on the data based on the requirements of downstream objects. For example, calculating a logarithmic value, converting from one currency value to another by multiplying with a conversion factor, etc.

Category: Tags: ,

Description

What is a Derived Column?

The Derived Column transformation creates new column values by applying expressions to transformation input columns. An expression can contain any combination of variables, functions, operators, and columns from the transformation input. The result can be added as a new column or inserted into an existing column as a replacement value. The Derived Column transformation can define multiple derived columns, and any variable or input columns can appear in multiple expressions.

Additional information

App Type

Input

Processing

Output

Product Tier