ETL: Pivot Transformation

Use the Pivot transformation to transpose rows into columns, converting unique field values into separate output columns in ETL pipelines.

The Pivot transformation transposes rows into columns, converting unique values from one field into separate output columns.

Overview

• Converts row-level values into column headers
• Requires a group-by field, a pivot field (whose values become columns), and a value field
• Applies an aggregation function when multiple values exist for the same group/pivot combination

Configuration

1. Select the group-by field(s) — these define each output row.
2. Select the pivot field — unique values in this field become new columns.
3. Select the value field — the data that populates the new columns.
4. Choose an aggregation function (SUM, COUNT, AVG, MIN, MAX) for cases where multiple values exist.

Example

Input with fields: Region, Quarter, Revenue.

Pivot on Quarter, group by Region, aggregate Revenue with SUM.

Result: one row per Region with columns Q1, Q2, Q3, Q4 containing revenue totals.