Using components: Unpivot Transformation

The Unpivot transformation component converts columns into rows by transforming wide data into long format. The unpivot component is the inverse of the pivot component and is useful for restructuring data where you want to transform multiple columns into row-based format, making it easier to analyze and compare values across different attributes.

Configuration

1. Unpivot Properties

Columns to narrow

Select the columns that should be converted from columns to rows. These columns will be transformed into rows with the column name stored in one column and the value stored in another column.

Attribute column

Specify the name for the column that will store the original column names (attribute names). This column will contain the names of the columns that were unpivoted.

Values column

Specify the name for the column that will store the values from the unpivoted columns. This column will contain the actual data values.

Example 1

Input data (Sales by Product and Quarter):

Unpivot configuration:

• Columns to narrow: ["Q1", "Q2", "Q3", "Q4"]
• Attribute column: "Quarter"
• Values column: "Sales"

Output data:

Example 2

Input data (Student scores by subject):

Unpivot configuration:

• Columns to narrow: ["Science", "History", "Math", "English"]
• Attribute column: "Subject"
• Values column: "Score"

Output data:

Important notes

• Unpivot is the inverse operation of Pivot - use unpivot to convert columns back to rows
• Use unpivot when you need to normalize data from wide to long format