Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference NOT
Functions and Expressions Reference Guide
154
NOT
The NOT function tests a condition and returns TRUE if the condition is not true
and FALSE if the condition is true.
Syntax
NOT (single-condition-expression)
Meaning
NOT (condition_to_evaluate)
Returns
This function returns TRUE or FALSE
Returns TRUE if the condition evaluates to FALSE.
Returns FALSE if the condition evaluates to TRUE.
Examples
NOT (Qty:.:InputFile = 0)
This example returns FALSE if the Qty equals 0 (the condition is true) and
returns TRUE if Qty does not equal 0 (the condition is false).
IF (NOT (PRESENT (StartDate)), "Unknown", NONE)
This example returns Unknown if StartDate is not present and returns NONE, if
StartDate is absent. Another way to test that an object is not present is to use
the
ABSENT function.
Uses
Use
NOT to test a condition and have it return the inverse of its TRUE or FALSE
result. For example, you want the function to return TRUE if the condition
results in FALSE.