Unpivot Table

../../../../_images/pivot_table.svg

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
Type: table
Description: Input Table

Output ports

Output
Type: table
Description: Output Table

Configuration

Index column (index)

Column that contains a unique identifier for each row

Examples

Example flows demonstrating this node:

Implementation

class node_unpivot_table.UnpivotTable[source]