Unpivot

Reshapes the data by merging one or more columns into key and value columns

Overview

The Unpivot node allows you to convert columns in your data table into row values. It involves converting wide-format data with multiple columns for different categories or attributes into long-format data, where each category or attribute is represented in a single row.

Settings

Convert to rows

Select the columns that you want to unpivot into rows. All columns' names will be stored in one column and their values in another.

Category column name

Enter a name for the new column to store the names of the unpivoted columns.

Value column name

Enter a name for the new column to store the values from the unpivoted columns.

Keep all other columns

Switch this toggle "on" to keep columns that were not unpivoted.

Example

Consider the following wide-format dataset:

The result of Unpivot:

Last updated 7 months ago