Data Transformation Engine Functions and Expressions Reference Guide

Functions and Expressions Reference Guide
9
Chapter 1 - Expressions and
Evaluations
This chapter explains how expressions are evaluated in component rules and map
rules.
Expressions
An expression is a statement about data objects. Expressions are used in
component rules in the Type Designer and in map rules in the Map Designer.
The following are examples of expressions:
Account Balance = Credits - Debits
TrunkRoom < 15
PRESENT (Store#:StoreInfo)
Note As you enter an expression, you may add spaces before and after component
names and operators to make the expression more readable. Additional spaces
have no effect on an expression.
Expressions are a combination of literals, object names, operators, functions, and
map names.
Component Rule Expressions Evaluate to True or False
Component rules are expressions that evaluate to TRUE or FALSE.
For example, the result of each of the following component rules is TRUE or
FALSE.
WHEN (PRESENT (Qualifier), PRESENT (Address))
COUNT (Exchange) < COUNT (Purchase)
Invoice#:Item = Invoice#:Item[1]