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.

Input Ports

Icon
Input data with collection column to split

Output Ports

Icon
The input data along with a newly append columns.

Popular Predecessors

Views

This node has no views

Workflows

Links

Developers

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.