The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Unpivoting

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

Dialog Options

Value columns
Include
This list contains the column names of the columns that are rotated into one single column.
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.)
Select
Use these buttons to move columns between the Include and Exclude list.
Search
Use one of these fields to search either within the Include or Exclude list for certain column names or name substrings. Repeated clicking of the search button marks the next column that matches the search text. The check box 'Mark all search hits' causes all matching columns to be selected making them movable between the two lists.
Exclude
This list contains the column names of the input table that are not rotated into the single column.
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.)
Retained columns
Include
This list contains the column names of the columns which that are duplicated by the number of selected value columns.
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.)
Select
Use these buttons to move columns between the Include and Exclude list.
Search
Use one of these fields to search either within the Include or Exclude list for certain column names or name substrings. Repeated clicking of the search button marks the next column that matches the search text. The check box 'Mark all search hits' causes all matching columns to be selected making them movable between the two lists.
Exclude
This list contains the column names of the input table that are not duplicated.
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.)
Options
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).

Ports

Input Ports
0 Input table with at least on value column for the unpivoting operation.
Output Ports
0 Unpivoting table with duplicated columns together with one rotated value column and their corresponding column names.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.