Unpivot Dataset

The dataset generated by pivoting columns is a dataset created by performing a pivot operation on the original dataset.

Create Pivot Dataset

1. Create a new dataset. Enter the dataset page, click on "New Dataset", and select "Unpivot".

2. Click on the dataset to be operated on, and the settings page appears on the right.

3. Set the transpose grouping column and transpose value column.

• Transpose Group Columns:
  • Group Column Name: The field name after the transpose column is converted to rows. The group column types include text, number, and date. The transpose column is the column to be converted to rows, where you can modify the group values and support adding multiple transpose columns.
  • Transpose Value Column: The new column name where the values of the transpose column are located after being converted to rows.

4. Click to preview the transposition result and check if the result meets expectations. After transposition, columns such as Robot, Manipulator, Auxiliary Machine, Water, Electricity, and Automation are transposed into rows and stored in the Component column (red box), while the values of the Robot, Manipulator, Auxiliary Machine, Water, Electricity, and Automation columns are stored in the Quantity column (blue box). The yellow box represents the fields from the original dataset, which are directly inherited in the transposed dataset.

5. Configure the data structure and save the dataset. Click Next to enter the data structure page. You can modify the field alias, set the field to display or hide, and then save the dataset.

Instructions

1. The fields of the dataset with columns converted to rows are divided into two parts: one part is the new fields resulting from the column-to-row conversion and their corresponding values, and the other part is the other fields from the original data.