When you double-click the Script Aggregator function, the function’s configuration dialog opens.
Script Aggregator Configuration Dialog
Group by
Specify the name of the input field key (or column name) based on the value you want to group the aggregated data by. Group by is a rule to group data records based on the same value stored in a column.
Note!
You can add multiple Group by rules. If you have multiple groups and the grouping cannot be performed on the basis of first rule, the next rule will be considered until a match is found. If a record does not match any of the Group by rule(s), 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: