Unpivot columns

Unpivot columns

Unpivots data


1 data source

What it does

This step will take every column that you indicate and line them up into a single column called Value. A new column will be created next to is called Type, that holds the value of the column header that each data point used to be in.

Why use it

Use this object if you need to change the structure of your data. If you have a table containing columns: Location, Profit, and Loss, you could use this Unpivot columns step to convert it into a table with the columns: Location, Type, and Value - where Type contains Profit or Loss, and Value is the number. This means you now have a row for each locations' profit and a row for each locations' loss.

The Unpivot columns step is useful if you need to apply the same steps to many columns of data. Simply unpivot them (which puts all of their values into a single row), apply the steps to that column, and use the Pivot columns step to return the data to its original form.

How to use it

Choose a unique ID column that will not be pivoted, and will be used as a key if the data needs to be pivoted back into shape.

Choose the columns to unpivot.

Optionally, you can choose to select the columns to exclude from the unpivot operation.

Try Parabola for free