1 ×

Split Collection Column

KNIME Base Nodes version 4.3.2.v202103021015 by KNIME AG, Zurich, Switzerland

This node splits a column containing a collection of cells into its sub-components. If a row contains more elements than implied by the various options (see below), the remaining elements are ignored. If it contains less elements than expected, the remaining columns are filled with missing values.


Column Selection
Select the column containing the collection value
Replace input column
Select this when the column containing the collection is to be removed the output.
Determine most specific type
The collection column often contains only general type information to the individual elements. Selecting this option will determine the most specific type of the newly appended column based on the actual content. If unsure, keep this option selected.
Element Count Policy
Select the policy on how to determine how many elements the input column contains. Three different modes are available:
  1. Count in advance: Perform one additional scan on the table and count the occurrences. The names of the new column's are auto-generated.
  2. Use input table information: Use the "element names" field in the collection column. This information may not always be present in the input table, in which case the node will fail its execution. The column names are defined by the element names.
  3. Best effort: Try to use the information from the input table; if none is available, count the occurrences.

Input Ports

Input data with collection column to split

Output Ports

The input data along with a newly append columns.

Best Friends (Incoming)

Best Friends (Outgoing)



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


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.