Unpivot Table¶
Documentation¶
Unpivot a Table.
The inverse operation of Pivot Table. The operation transforms data from a wide to a narrow format. The wide form can be considered as a matrix of column values, while the narrow form is a natural encoding of a sparse matrix. When the data types of value columns differ, the varying data is converted to a common data type so the source data can be part of one single column in the new data set.
Definition¶
- Input ports:
- Input
table
Input Table
- Output ports:
- Output
table
Output Table
- Configuration:
- Index column (index)
Column that contains a unique identifier for each row