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.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers