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.

Popular Predecessors

Popular Successors

  • No recommendations found


This node has no views


  • No workflows found



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.