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.