Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Expressions That Evaluate to NONE
Functions and Expressions Reference Guide
36
Expressions That Evaluate to NONE
The following discussion explains how the Map Designer evaluates an expression
when expressions within it evaluate to NONE.
When an Operand Evaluates to NONE
The following table explains how an operator expression evaluates when an
operand evaluates to NONE.
The symbol
A represents one operand of the expression and B represents the
other operand.
The symbol
!= means not equal to.
Operator Expression Condition Expression Evaluates to
A / B A = NONE B = NONE NONE
A*B A = NONE B = NONE NONE
A / B A != NONE B = NONE 0
A*B A != NONE B = NONE 0
A + B A = NONE B = NONE NONE
A - B A = NONE B = NONE NONE
A + B A = NONE B != NONE B
A - B A = NONE B != NONE -B
A + B A != NONE B = NONE A
A - B A != NONE B = NONE A
A > B A = NONE B = NONE FALSE
A < B A = NONE B = NONE FALSE
A = B A = NONE B = NONE TRUE
A > B A = NONE B != NONE FALSE
A < B A = NONE B != NONE TRUE
A = B A = NONE B != NONE FALSE