Articles on: Transforms

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.

Unpivot columns


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"

Updated on: 20/09/2022

Was this article helpful?

Share your feedback


Thank you!