Unpivot columns
The Unpivot columns step display the data based on each value from the identified column(s) with its correspondent row cells and column headers.
The input data we'll use for this step is a table of colors and quantities for products.
Below is a screenshot of our output data after using this Unpivot columns step. The Identified column name is "Color", the "Products" column is taken from correspondent columns headers and the "Quantity" column taken from correspondent row cells.
Pick the dataset, type in "Column identifiers" the column names or indexes that will be considered as unique identifiers during the unpivot process. Multiple columns separated by comma,
then, type the "New column - pivot" and "New column - value"
Unpivot columns
Input/output
The input data we'll use for this step is a table of colors and quantities for products.
Below is a screenshot of our output data after using this Unpivot columns step. The Identified column name is "Color", the "Products" column is taken from correspondent columns headers and the "Quantity" column taken from correspondent row cells.
Settings
Pick the dataset, type in "Column identifiers" the column names or indexes that will be considered as unique identifiers during the unpivot process. Multiple columns separated by comma,
then, type the "New column - pivot" and "New column - value"
Updated on: 20/09/2022
Thank you!