Description
Operations are commutative if the order of operands can change without changing the result. So the same block is used to do the following operations:
-
Sum
-
Average
-
Product
-
First
-
Last
-
Min
-
Max
-
Or
-
And
-
Count
These operations are all applied on columns to compute a result and columns order doesn't matter.
The operations will happen a new column to the previous tables, so all the columns will remain available and an additional column will appear.
Implementation
Properties
-
Artifacts: Artifacts created by this block
-
Tables: the resulting table.
-
-
Target: the table on which the operation will be applied.
-
ColumnName: The name of the new column containing the result.
-
Columns: The columns to compute on. SFormat should be used, basically column() or columns() functions.
-
Operator: The operator to use.
Summary
