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 "Product", "Color", "Quantity" and "Stock" columns.

The "Product" values will becomes the column headers and the "Color" values will becomes the cell value in the corresponding columns.

Settings

Pick the dataset, then Type the "Pivot column" to specify the column name or index. The values of this column will be converted to new columns as part of the pivot process.

Type the "Value column" to specify the column name or index. The values of this column will be distributed under the new create pivot columns.