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 |