Unpivot (Line Items)

Unpivot (Line Items)

Unpivots data


1 data source

What it does

Unpivots a set of data. This object 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 Object 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 object 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 object to return the data to its original form.

How to use it

Choose a unique ID column that will not be unpivoted, 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.

Start automating with Parabola

Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.