Calculations

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

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

Aggregate

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

Aggregate transformation


Read next: Merging data