Average

Calculates the average of the values from several numerical source columns one row at a time, writes the result to a target column, and overwrites any existing values there. If the target column does not exist, it is created.

The following parameters are available.

Parameter

Description

Column

Name of the column for which the average value is calculated. Column is transferred from the source table.

Data type: Number

Specification: Mandatory

Weight

Weight factor, which can be specified for each column to be aggregated: a column with values, a single value from a feed (single-value operator), an input value or a constant.

Data type: Number

Specification: Optional

Target column

Name of the column to which the result is written. The column name can be transferred from the source table or freely entered.

Data type: Number

Default value: Result_1

Specification: Mandatory