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.

Split Collection Column

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.

Dialog Options

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.

Ports

Input Ports
0 Input data with collection column to split
Output Ports
0 The input data along with a newly append columns.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.