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
Select the group-by field(s) — these define each output row.
Select the pivot field — unique values in this field become new columns.
Select the value field — the data that populates the new columns.
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. Last modified on April 20, 2026
