<< Click to Display Table of Contents >> Navigation:  5. Detailed description of the Actions > 5.5. Standard > 5.5.5. Aggregate (Group by) (High-Speed action) > 5.5.5.5. Dynamic Aggregation

 

It can happen on some occasion that you don’t know “in advance” the precise nature of the aggregation that you want to compute: i.e. you need to run some computation to now exactly which aggregations to compute. In such situation, you should use the second and third input pin (pin 1 and 2) from the  Aggregate Action. More precisely,
 

•The second table contains the “group by” information. It only has one column that contains the names of all the “group by” columns.
 

•The third table contains the “output column” information. It only has two columns:
 

oThe first column is the name of the variable to process/aggregate.
 

oThe second column contains a string that describes the aggregate to compute.

The accepted values are (case insensitive):
 

▪IMin (number minimum)

▪IMax (number maximum)

▪SMin (string minimum)

▪SMax (string maximum)

▪First

▪Last

▪Sum

▪Mean

▪StdDev

▪CountDistinct

▪CountNonEmpty

▪CountNonNull

▪MostCommonModality

▪CountMostCommonModality