Aggregate


Synopsis

Performs one of the aggregation functions (count, sum...) known from SQL (allows also grouping).


Description

This operator creates a new example set from the input example set showing the results of arbitrary aggregation functions (as SUM, COUNT etc. known from SQL). Before the values of different rows are aggregated into a new row the rows might be grouped by the values of a multiple attributes (similar to the group-by clause known from SQL). In this case a new line will be created for each group.

Please note that the known HAVING clause from SQL can be simulated by an additional ExampleFilter operator following this one.


Input


Output


Parameters


ExampleProcess