Skip to main content

Columns to Rows

1. Overview

Columns to rows is the inverse operation of rows to columns. Through columns to rows, multiple metrics can be summarized into one column for analysis and display.

For example, convert the following two rows: Chinese, Math and 89, 100 to columns, naming the column names as Subject and Score respectively.

|550

2. Operation Steps

  1. Drag the "Columns to Rows" operator from the data flow operator area into the right canvas editing area;

  2. Click the "Columns to Rows" operator and set the label column name and value column name;

    |300

  3. Click "Add" to add columns that need column-to-row operations (can add multiple);

    |550

  4. After configuration is complete, preview the data results.

3. Specific Case

The following introduces configuring a Student Exam Score Statistics as an example.

Convert the following table data into a new table composed of three columns: Name-Subject-Score. Preview before conversion:

  1. Drag the "Columns to Rows" operator from the data flow operator area into the right canvas editing area and connect it to the upstream node;

  2. Click the "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

    |550

  3. Click Add to select columns for column-to-row operations;

    |550

  4. Click "Preview" to preview the data results to ensure that the data after column-to-row conversion meets expectations and does not contain errors or abnormal values.