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




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

Was this article helpful?

Share your feedback

Cancel

Thank you!