CommutativeBlock

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