0 ×

Create Collection Column

StreamableKNIME Base Nodes version 3.6.2.v201811051556 by KNIME AG, Zurich, Switzerland

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.

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.

Input Ports

Any input data

Output Ports

The input data along with a newly append collection column.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

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

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.