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 |