Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ABSENT
Functions and Expressions Reference Guide
59
ABSENT
The ABSENT function tests for the absence of an object.
Syntax
ABSENT (single-object-expression)
Meaning
ABSENT (object_to_test)
Returns
This function returns TRUE or FALSE.
Returns TRUE if the
object_to_test evaluates to NONE.
Returns FALSE if the object_to_test does not evaluate to NONE.
Example
ABSENT (AreaCode:Phone)
This example evaluates to TRUE if AreaCode:Phone evaluates to NONE and
evaluates to FALSE if
AreaCode:Phone does not evaluate to NONE.
Uses
You may want to map an object only if another object is absent. For example,
you may want to map BillTo information to the ShipTo fields if the
ShipToName is absent.
Related Function
PRESENT