Conditional replace

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