Calculate column

Calculate new column transformation allows calculating new columns using expressions (i.e. formulas).

Calculate new column transformation
Similarly, Modify column transformation replaces existing columns. Note that it's possible to create/modify several columns in one transformation.


Rule transformation can be used for calculations that are nested IF/THEN/ELSE conditions. This transformation is similar to CASE statements in SQL. It can be used to create new columns as well as replaces existing ones.

Rule transformation


To calculate grouped aggregates such as sum or count, use Aggregate transformation.

Aggregate transformation

Read next: Merging data