<< Click to Display Table of Contents >> Navigation:  5. Detailed description of the Actions > 5.17. TA - Time Series > 5.17.1. Aggregate on Columns (High-Speed action)

 

Icon:

 
Function: SumOnColumns

 

Property window:

 

 

Short description:

 

Sum some columns.

 

Long Description:

 

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 Anatella graph 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 (see section 5.3.2. about multithreading).