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.
Create Collection Column
This node aggregates multiple columns in a separate new column, whose
type is a "collection type". The cells in the new column are typed
collections of cells; that is, the content can be safely be split into
the original column content. The reverse operation is available
in the "Split Collection Column" node.
Dialog Options
Column Filter
- Include
-
This list contains the column names that are aggregated in a separate
new column.
- Enforce Inclusion
-
Select this option to enforce the current inclusion list to stay
the same even if the input table specification changes.
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 included in the collection cell.
- Enforce Exclusion
-
Select this option to enforce the current exclusion list to stay
the same even if the input table specification changes.
New columns will automatically be added to the inclusion list.
Collection type
- Create a collection of type 'set' (doesn't store duplicate values)
-
If checked, a collection column of type set is created. Set collections
contain only distinct values, duplicates are deleted.
- ignore missing values
-
If checked, missing values are ignored, i.e. not stored in collection
cells.
Output table structure
- Remove aggregated columns from table
-
If checked, aggregated columns are removed from out put table.
- Enter the name of the new column
-
Specifies the name of the new column containing the collection cells.
Ports
Output Ports
0 |
The input data along with a newly append collection column. |
This node is contained in KNIME Base Nodes
provided by KNIME GmbH, Konstanz, Germany.