This is an example to illustrate the Aggregate Snap with Functions like Sum, Count, Min, Max and Average.
The 1st Snap generates the required input data like Name, Age, Dept, etc.
The next Snap “Aggregate” is configured with functions like
- Sum of Age for Total Age
- Count of Name (Unique column) for Total employee
- Min of Age for Minimum Age
- Max of Age for Maxiumum Age
- Avg of Age for Average Age
Below is the quick screen shot of the configuration of the functions of this Snap.
Attached is the .slp for the pipeline reference of this example.Aggregate_2017_03_11.slp (6.0 KB)