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.

Column Aggregator

Groups the selected columns per row and aggregates their cells using the selected aggregation method.

To change the name of the new created aggregation column double click on the name column.

A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.

Dialog Options

Columns
Columns
Select one or more column to aggregate.
Enforce exclusion
Select this option to enforce the current exclusion list to stay the same even if the input table specification changes. If some of the excluded columns are not available anymore, a warning is displayed. (New columns will automatically be added to the inclusion list.)
Enforce inclusion
Select this option to enforce the current inclusion list to stay the same even if the input table specification changes. If some of the included columns are not available anymore, a warning is displayed. (New columns will automatically be added to the exclusion list.)
Options
Aggregation settings
Select one or more aggregation method from the available method list. Only methods that are compatible to the selected aggregation columns are displayed. Change the name of the aggregation column by double clicking the name cell. You can add the same method multiple times. However you have to change the name of the result column. Tick the missing box to include missing values. This option might be disabled if the aggregation method does not support missing values. The parameter column shows an "Edit" button for all aggregation operators that require additional information. Clicking on the "Edit" button opens the parameter dialog which allows changing the operator specific settings.
Remove aggregation column
Select this option to remove the selected aggregation columns from the result table.
Remove retained column
Select this option to remove the retained columns from the result table.
Maximum unique values per row
Defines the maximum number of unique values per row to avoid problems with memory overloading. All row with more unique values are skipped during the calculation and a missing value is set in the corresponding row, and a warning is displayed.
Value delimiter
The value delimiter used by aggregation methods such as concatenate.
Revert selected names
This option is available in the context menu and reverts the name of the result columns of the selected methods to their default names.
Missing
Missing values are considered during aggregation if the missing option is ticked for the corresponding row in the column aggregation table. Some aggregation methods do not support the changing of the missing option such as means.

Ports

Input Ports
0 The input table to aggregate.
Output Ports
0 Result table with the aggregation columns per row.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.