The Unpivot transform combines multiple columns into a single column containing new rows (opposite of Pivot).
The Unpivot transform requires one input transform that has at least three columns.
For example, the input could be a SQL Select transform that corresponds to the following Excel sheet:
In the Unpivot configuration dialog, you need to configure the following settings:
Set Unpivot Column Name to name the new column that will contain the names of all of the unpivoted columns (e.g., the days of the week in our example).
Set Value Column Name to name the new column that will contain all of the unpivoted column values.
The figure below illustrates the output from the Unpivot transform in our example.