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.

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.

Views

This node has no views

Workflows

• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflowKNIME Hub
• [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 00 Data GenerationKNIME Hub
• Show all 612 workflows

Links

• how to merge tables, one with single instance and the other with multiple instances for a unique IDby armingrudd on 2019-09-26

  forum.knime.com/p/71082
• GC overhead limit exceeded while Tree Buildingby qqilihq on 2018-06-05

  forum.knime.com/p/43724

Developers