Uncollapse Columns

Overview

This operator supports converting row dimensions in a data table into column dimensions.

For example, accessory categories can be converted into columns, with sales amount used as the fill value.

Instructions

Steps

1. Drag the Pivot Rows to Columns operator from the ETL operator area to the canvas on the right.
2. Click the Pivot Rows to Columns operator and select the column to pivot, the fill value for the new columns, and the aggregation type.
3. Click Add, choose the primary key columns, and enter the names of the new columns.
4. After configuration is complete, preview the data result.

Detailed Explanation

The following example shows how to configure Platform.

Convert the category column into columns and use sales amount as the fill value. Preview before conversion:

1. Drag the Uncollapse Columns operator from the ETL operator area to the canvas on the right and connect it after the upstream node.

2. Click the Pivot Rows to Columns operator. The left panel becomes the current operator configuration area. Select the column to pivot, the fill value for the new columns, and the aggregation type.

   • Column to pivot: Platform
   • Data column used to fill the new columns: Revenue_RMB
   • Aggregation type: Sum
   

3. Click Add, choose the primary key column, and enter the new column names.

   Notes

   The primary key determines which key the Output Dataset is based on. If multiple primary key columns are selected, they form a composite key, and the Output Dataset is generated based on that composite key.

   • Primary Key Column: Date
   • New Column Names: Meituan, Eleme, In Store, Other
   

4. Click Preview to preview the data result and ensure that the pivoted result matches expectations and does not contain errors or abnormal values.

   

For other data processing operators used later, see Getting Started.