Exists - script function

Exists() determines whether a specific field value has already been loaded into the field in the data load script. The function returns TRUE or FALSE, so can be used in the where clause of a LOAD statement or an IF statement.

Syntax:  

Exists(field_name [, expr])

Return data type: Boolean

Arguments:  

Argument Description
field_name A name or a string expression evaluating to a field name to be searched for. The field must exist in the data loaded so far by the script.
expr An expression evaluating to the field value to look for in the field specified in field-name. If omitted, the current record’s value in the specified field is assumed.