¶ Description
Computes aggregates (count, sum, mean, ....) on a row.
¶ Parameters
Parameters:
- Abort if a column is missing
- Check sort metadata on pin 1
- Omit suffix on output column name when possible
- Output columns
¶ About
This action creates some new columns that are the sum of the selected columns. For example:
The table connected to the pin 0 of the AggregateOnColumns action is the table on which to compute all the aggregation. The table connected to the pin 1 of the AggregateOnColumns action is optional. This optional 3-columns-table defines some additional aggregations to compute. For example, the above ETL pipeline is equivalent to:
The third column on the second input pin (i.e. the column “Op” in the example above) may contain the following strings (case insensitive): imin, imax, smin, smax, first (first non-null), last (last non-null), mean, product, geometricMean, stdDev, countDistinct, countNonEmpty, countNonNull, countNonZero, mostCommonModality, countMostCommonModality.
The AggregateOnColumns action can run inside a N-Way multithreaded section.
