View Navigation
Product Overview
Account Overview
Integrations
Transforms
Security
Transforms   ->

Pivot columns

The Pivot columns step takes a column and turns its values into multiple columns. It is particularly useful when needing to turn order line item information into a unique row per order.

Input/Output

In the example below, our input data has repeated "Order Ids" with columns containing "Variant Options" and  "Variant Values".

We'll want to create a unique row per "Order ID" where the "Variant Option" becomes the column headers and "Variant Value" becomes the cell value in the corresponding columns. The Pivot columns step accomplishes this for us.

After using this step, the output data below shows how it made the unique "Variant Options"   our column headers and the corresponding "Variant Values" as the row values.

Custom settings

Once you connect data to the Pivot columns step, you'll select a column from the Pivot Column dropdown and you'll select another column from the Value Column dropdown.

The Pivot Column is the column that will be the new column headers. In the example below, we selected the "Variant Options" column to be the pivot column.

The Value Column is the column that will be the cell values for the corresponding column headers. As seen in the below example, we selected "Variant Value" column to be the value column. If no "Variant Value" exists for the corresponding "Variant Options" column header, the row cell is left blank.