Aggregation

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.

Options

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

Icon
The input relation.

Output Ports

Icon
The output relation resulting from the aggregation.

Popular Predecessors

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

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.