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.

Ungroup

Creates for each list of collection values a list of rows with the values of the collection in one column and all other columns given from the original row. Rows with an empty collection are skipped, as well as rows that contain only missing values in the collection cell with the 'Skip missing values' option enabled.

Dialog Options

Collection column
The collection column to ungroup.
Remove selected collection column
The selected collection column will be removed from the result table, if this option is ticked.
Skip missing values
If enabled, rows with a missing value in the collection column are skipped, as well as missing values in a collection cell.
Enable hiliting
If enabled, the hiliting of a input row results in hilting all rows (given in the collection cell) of the ungrouped output table vs. if all output rows (represented in or more collection cell) the input row(s) are hilit as well. Depending on the number of rows, enabling this feature might consume a lot of memory.

Ports

Input Ports
0 The input table to ungroup
Output Ports
0 Ungrouped table
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.