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

Input Ports
0 Any input data
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.