<< Click to Display Table of Contents >> Current:  Create Data Set > Self-Service Data Set  Unpivot

Unpivot Table node is a data processing operation to convert multi-dimension to one dimension. This is a multidimensional data as shown below:

In "Unpivot" dialog, there are two column property settings: "Keep Columns" and "Convert Columns." As shown in the following figure, add "ID" and "ClassNo." to Keep Columns, and "Math", "Chinese", and "English" to Convert Columns.

[Data Columns] Display all the visible columns of the input node.

[Keep Columns] Column remaining data unchanged.

[Convert Columns] Column requiring conversion from multi-dimension to one dimension.

Data after Unpivot processing are as follows. Math, Chinese, and English in converting columns are converted from multi-dimension to one dimension: