Basic information
Category: General
Available from version: 1.0.x
Description
Function to group data based on given grouping values. It is possible to call specific aggregating functions on grouped data. The resulting data is returned as TableStore object.
Configuration parameters
| Parameter name | From version | Description | Parameter type | Default value | Field type | Comments and restrictions |
|---|---|---|---|---|---|---|
| Agregate function | 1.0.x | The set of functions that can be called on the given variable. | Text array | Drop-down list | Available functions: AVG, CONCAT, COUNT, MAX, MIN, SUM. The following value can be selected from the list: GROUPPARAM - used when the variable is to be used only for grouping (we do not want to aggregate its value). | |
| Variable* | 1.0.x | Variables whose values are to be aggregated after grouping. | Variable array | Editable field | ||
| Concat separator | 1.0.x | Separator with which the values after grouping will be joined. | Text | Editable field | Shows when CONCAT is selected from the Aggregate Function parameter. If several CONCAT Functions are added, the separator is common to them. | |
| Group by* | 1.0.x | Variables are grouped based on their values. | Variable array | Editable field |
Parameter*- required field
Sample configuration
Grouping by indeksy column:
Grouping by indeksy and login columns:
Usage example
Change log
1.0.X
- Adding component
Parameter