Aggregate Functions

Aggregate functions enable you to calculate summaries of numerical data, and also concatenate string values.

Use the Aggregate step in the data flow editor to access various types of summary that you can use to prepare your data.

Function	Description
Average	Calculate the average of values in the column.
Count	Count the number of rows in the column.
Count Distinct	Count the number of unique rows in the column.
List Aggregate	Concatentate all values in the column into one string. For example, if the column contains New York, New York, Boston, Salem, Buffalo, Buffalo, Albany, then the generated string is "New York, New York, Boston, Salem, Buffalo, Buffalo, Albany".
List Aggregate Distinct	Concatentate unique values in the column into one string. In other words, ignore duplicate values. For example, if the column contains New York, New York, Boston, Salem, Buffalo, Buffalo, Albany, then the generated string is "New York, Boston, Salem, Buffalo".
Maximum	Calculate the maximum value in the column.
Minimum	Calculate the minimum value in the column.
Sum	Calculate the sum of values in the column.