The Unpivot transformation transposes columns into rows, converting multiple columns into key-value pairs.
Overview
- The reverse of Pivot — converts columns back to rows
- Useful for normalizing wide tables into long format
- Produces two output fields: one for the column name and one for the value
Configuration
Select the columns to unpivot — these become row values.
Select the columns to keep as-is (passthrough fields).
Name the output field for column names (e.g., “attribute”).
Name the output field for values (e.g., “value”).
Example
Input: Region, Q1, Q2, Q3, Q4.
Unpivot Q1—Q4.
Result: Region, Quarter, Revenue — one row per region/quarter combination. Last modified on April 20, 2026
