Reducer processor supports:
-
Aggregation functions such as Count, Avg, Sum, Min, and Max.
-
Grouping of columns
-
Enter the values for the following parameters in the Basic section.
-
Name – Specify the name
-
Aggregate Expressions – Aggregation functions such as Count, Avg, Sum, Min, and Max.
For example, Reducer process configured to produce the Min and Max Start Date.
-
Previous Step Entity Set
Project ID |
Period |
---|---|
1 |
1/2018 |
2 |
1/2019 |
3 |
1/2020 |
Result Entity Set
Min_Period |
Max_Period |
---|---|
2018 |
2020 |
2. In the Advanced section, click Grouping Attributes.
The Group Attributes window appears.
For example: Reducer process configured to produce the Min and Max Start Date grouped by Location.
Previous Step Entity Set
ProjectId |
Location |
Period |
---|---|---|
1 |
NY |
1/2018 |
1 |
NY |
1/2019 |
1 |
CA |
1/2020 |
Result Entity Set
Location |
Min period |
Max period |
---|---|---|
NY |
1/2018 |
1/2019 |
CA |
1/2020 |
1/2020 |
eLearning is available for this topic. Check it out here: Course link.