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:
- Count in advance: Perform one additional scan on the table
and count the occurrences. The names of the new column's are
auto-generated.
- 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.
- 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.