Changes the value in the specified column one row at a time if certain conditions are met.
Replaces existing values in the column with new values. Replacement must be linked to a condition, that is, you can specify whether all or at least one condition must be met. Several conditions can be specified and these are linked to each other with "AND".
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 |
Comparison operators
The following comparison operators are available.
Data type |
Comparison operators |
Number |
Is equal to Is not equal to Is less than Is less than or equal to Is greater than Is greater than or equal to Is empty Is not empty |
Text |
Is equal to Is not equal to Starts with Ends with Contains Does not contain Is empty Is not empty |
Date |
Before After On Before or on On or after Is empty Is not empty |