...
When you double-click the Script Aggregator function, the function’s configuration dialog opens.
...
Script Aggregator Configuration Dialog
Group by
Specify the name of Select the field(s) in the input field key (or column name) based on the value data (displayed as columns in the interface) that you want to group the aggregated data by. For example, if you select Day, a session will be created for each unique value for Day contained in the input data. Each row of Fields is a Group by rule, and you can add multiple fields in each rule. A new session will be created for each unique combination.
| Info |
|---|
Example- Group by rules Group by a single field  The field ‘day’ is added to a Group by rule. This will group the input data based on values in the day column. The following data records are received: Record 1: Day=Monday Record 2: Day=Wednesday Record 3: Day=Monday Result: Two sessions are created
Group by two fields  The fields ‘day’ and 'country' are added to a Group by rule. This will group the input data |
...
based on |
...
values in the day column and the country column. The following data records are received: Record 1: Day=Monday, Country=Sweden Record 2: Day=Wednesday, Country=France Record 3: Day=Monday, Country=France Record 4: Day=Monday, Country=Sweden Record 5: Day=Wednesday, Country=France Record 6: Day=Monday, Country= Sweden Result: Three sessions are created:
|
Note!
You can also add multiple Group by rules. If
...
the grouping cannot be performed based on the
...
first rule, the next rule will be considered until a match is found. If a record does not match any of the Group by
...
rules, the stream will abort.
If you do not specify anything in Group by, aggregation will be performed based on all the columns.
Script block
You can define the custom logic using the following tabs:
...