0 ×


org.andl.ra version by andl

Outputs the projection of a relation (table) onto a set of attributes (columns), comprising a set of grouping attributes and one aggregate. The value of the aggregate is calculated for each group, according to the selected aggregation function. The aggregate attribute is given a new name.


Select grouping
Specify which are the grouping attributes. The others are available for aggregation.
Column to Aggregate
Specify which column (attribute) should be aggregated.
Aggregation function
Specify the function to perform the aggregation. The available functions for all attribute types are Count, Max and Min. Sum and Average are only valid for numeric attributes.
Name for Aggregated Column
Specify the new name for the aggregated attribute.

Input Ports

The input relation.

Output Ports

The output relation resulting from the aggregation.

Best Friends (Incoming)


To use this node in KNIME, download the below referenced file, save it to your KNIME's plugin folder and restart KNIME.


You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.