ETL: Unpivot Transformation

Use the Unpivot transformation to transpose columns into rows, converting multiple columns into key-value pairs in your ETL data pipeline.

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

1. Select the columns to unpivot — these become row values.
2. Select the columns to keep as-is (passthrough fields).
3. Name the output field for column names (e.g., “attribute”).
4. 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.