Azure Data Factory Data Flow Aggregate and Sort transformations can be used similarly to SQL Groups and aggregates such as COUNT, SUM, MIN, etc.
The Aggregate and Sort transformations are used against our existing Maintenance Tickets table to count the number of Maintenance Type occurrences which have tickets at each of the buildings. The records are grouped by Maintenance Type and then Building:
There is an aggregate for the count of Maintenance Type in the “Aggregate” tab, count(Maintenance_Type) and saved with the name “Occurrences”.
The results are then sorted Maintenance Type and then by Building:
Now you can view Data preview to see the sorted sort:
For reference, review https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate and https://learn.microsoft.com/en-us/azure/data-factory/data-flow-sort.
Categories: Azure Data Factory
Leave a Reply