Aggregate (In Database)
(In-Database Processing)
Synopsis
Performs an aggregation / GROUP BY operation on the current result.Description
This operator performs the well known GROUP BY operation using the specified list of grouping attributes. It then applies the specified aggregate functions on the selected columns. The aggregate functions can be defined in two different ways: either explicitly in a list, or by using the attribute selector and specifying a default aggregation function for these columns. The two methods can be combined. Note that the known HAVING clause from SQL can be simulated by an additional Filter Examples operator following this one.
Input
example set input
Output
- example set output
Parameters
- use_default_aggregation If checked you can select a default aggregation function for a subset of the attributes. Range: boolean
- attribute_filter_type The condition specifies which attributes are selected or affected by this operator. Range: selection
- attribute The attribute which should be chosen. Range: string
- attributes The attribute which should be chosen. Range: string
- regular_expression A regular expression for the names of the attributes which should be kept. Range: string
- use_except_expression If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression. Range: boolean
- except_regular_expression A regular expression for the names of the attributes which should be filtered out although matching the above regular expression. Range: string
- value_type The value type of the attributes. Range: selection
- use_value_type_exception If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type. Range: boolean
- except_value_type Except this value type. Range: selection
- block_type The block type of the attributes. Range: selection
- use_block_type_exception If enabled, an exception to the specified block type might be specified. Range: boolean
- except_block_type Except this block type. Range: selection
- numeric_condition Parameter string for the condition, e.g. '>= 5' Range: string
- invert_selection Indicates if only attributes should be accepted which would normally filtered. Range: boolean
- default_aggregation_function The type of the used aggregation function for all default attributes. Range: string
- aggregation_attributes The attributes which should be aggregated. Range: list
- group_by_attributes Performs a grouping by the values of the attributes by the selected attributes. Range: string