The Unpivot transform allows combining multiple columns into a single column (opposite of Pivot).
The Unpivot transform requires 1 input transform that has at least 3 columns.
For example, the input could be a SQL Select transform that corresponds to the following Excel sheet:
In the Unpivot configuration dialog, you must configure the following settings:
- Unpivot Column Name - The new column name in which the column names which are going to be un-pivoted will be placed into as values. (e.g. the DayOfWeek column from the Excel sheet). This column will be part of the output as well.
- Value Column Name - The new column name in which the value of the columns to be un-pivoted will be place into. (e.g. the Sales column from the Excel sheet).
- Unpivot columns - columns that will be unpivoted.
The figure below illustrates the output from the Un-Pivot transform as applied to the Excel sheet.