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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?