Parameters

The following parameters are available.

Action

Result

Column

Name of the column whose values are replaced.

Source: Source table

Data type: Number, Text, Date;

Specification: Mandatory

New value

Value that replaces the value in the source column.

Source: Column with values, single value from a feed (single-value operator), user input, or a constant.

Default value: is equal to

Specification: Mandatory

Replace

Values are replaced if one or all conditions is/are met.

Source column

Name of the column whose values are compared.

Source: Source table

Data type: Number, Text, Date;

Specification: Mandatory

Comparison operator

Operator that compares the values from the source column with the comparison values.

Available comparison operators depend on the data type of the source column.

Default value: is equal to

Specification: Mandatory

Comparison values

Values that are compared with the values from the source column.

Source: Column with values, single value from a feed (single-value operator), user input, or a constant.

Data type: Must be identical to that of the source column.

Comparison value missing

Condition met: If a comparison value is missing, the condition is assumed to be met.

Condition not met: If a comparison value is missing, the condition is assumed to not be met.

Specification: Mandatory