Column

Name of the column whose values are searched.

Source: Source table

Data type: Text

Specification: Mandatory

Search text

String for which the search is performed.

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

Data type: Text

Specification: Mandatory

Target column

Name of the column to which the search result is written. This can be either a new column (typing a column name in the text field) or existing column (selecting a column from the drop-down menu).

Data type: Number

Default value: Result_1

Specification: Mandatory

First/last hit

If multiple results are found, the first or last hit is taken as the search result.