Skip to main content

Unpivot Columns to Rows

1. Overview

Unpivoting columns to rows is the reverse operation of pivoting rows to columns. By unpivoting, multiple metrics can be aggregated into a single column for analysis and display.

For example, convert the following two rows: Chinese, Math and 89, 100, into columns named Subject and Score.

image.png

2. Usage Instructions

2.1. Operation Steps

  1. Drag the Unpivot Columns to Rows operator from the ETL operator area to the right canvas editing area;
  2. Click the Unpivot Columns to Rows operator, set the label column name and value column name;
  3. Click Add to add the columns to be unpivoted (multiple can be added);
  4. After configuration, preview the data result.

image.png

2.2. Detailed Description

Below is an example of configuring Student Exam Score Statistics.

Convert the following table data into a new table consisting of three columns: Name, Subject, and Score. Preview before conversion:

image.png

  1. Drag the Unpivot Columns to Rows operator from the ETL operator area to the right canvas editing area and connect it to the upstream node;
  2. Click the Unpivot Columns to Rows operator, the left area becomes the current operator configuration area. Set the label column name and value column name:
  • Label column: Subject
  • Value column: Score

image.png

  1. Click Add to select the columns to be unpivoted;

image.png

  1. Click Preview to preview the data result and ensure the unpivoted data meets expectations and contains no errors or anomalies.

image.png

For subsequent use of other data processing operators, see Getting Started.