1 ×

Unpivoting

KNIME Base Nodes version 4.0.0.v201906241150 by KNIME AG, Zurich, Switzerland

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

Options

Value columns

Include
This list contains the names of the columns that are rotated into one single column.

Retained columns

Include
This list contains the column names of the columns which are duplicated by the number of selected value columns.

Manual Selection

Filter
Use one of these fields to filter either the Include or Exclude list for certain column names or name substrings.
Buttons
Use these buttons to move columns between the Include and Exclude list. Single-arrow buttons will move all selected columns. Double-arrow buttons will move all columns (filtering is taken into account).
Enforce Inclusion
Select this option to enforce the current inclusion list to stay the same even if the input table specification changes. If some of the included columns are not available anymore, a warning is displayed. (New columns will automatically be added to the exclusion list.)
Enforce Exclusion
Select this option to enforce the current exclusion list to stay the same even if the input table specification changes. If some of the excluded columns are not available anymore, a warning is displayed. (New columns will automatically be added to the inclusion list.)

Wildcard/Regex Selection

Type a search pattern which matches columns to move into the Include list. You can use either Wildcards ('?' matching any character, '*' matching a sequence of any characters) or Regex. You can specify whether your pattern should be case sensitive.

Type Selection

Select the column types that you want to include. Column types that are currently not present are depicted in italic.
Enable hiliting
Select, if hiliting is enabled between input and output data.
Skip rows containing missing cells
Skip all rows containing missing cells in selected value column(s).

Input Ports

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

Output Ports

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

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Base Nodes from the following update site:

KNIME 4.0
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.