Unpivoting – KNIME Hub

Node / Manipulator

Unpivoting

Manipulation Row Transform

This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example:

			Input:
				Value1 Value2 Value3 Extra1 Extra2 Extra3
			Output:
				Value1 Extra1 Extra2 Extra3
				Value2 Extra1 Extra2 Extra3
				Value3 Extra1 Extra2 Extra3

Node details

Ports Options Views

Input ports

Type: Table

Data table

Input table with at least on value column for the unpivoting operation.

Output ports

Type: Table

Unpivoting table

Unpivoting table with duplicated columns together with one rotated value column and their corresponding column names.

Extension

The Unpivoting node is part of this extension:

Go to item