Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference EITHER
Functions and Expressions Reference Guide
99
of Reference#. If none of those conditions result in a value, EITHER returns
"####".
Uses
Use
EITHER when you want a default when an expression evaluates to NONE
and the expression may cause common arguments to produce an unintended
result. For example, use
EITHER (LOOKUP (PriorityCd:Msg , CustID:Msg = "93X") , 8)
- instead of -
IF (PRESENT (LOOKUP (PriorityCd:Msg , CustID:Msg = "93X" ) ),
LOOKUP ( PriorityCd:Msg , CustID:Msg = "93X" ) , 8 )