Data Transformation Engine Map Designer Reference Guide

Chapter 6 - Map Rules A Map Rule is an Expression
Map Designer Reference Guide
105
To disable color coding
1 Disable the Use color coding check box.
A Map Rule is an Expression
Each map rule begins with an equal sign (=), followed by an expression.
A map rule is an expression that evaluates to data. An expression is any valid
combination of literals, data object names, operators, functions and map names.
The expression in a map rule generates the desired data. For example:
♦ The expression
Name Field:Input evaluates to the value of the data object
Name, which is a subtype of Field, which is a component of the data object
Input.
♦ The expression
500 evaluates to a data object with a value of 500.
♦ The expression
COUNT (Record:OrderFile) evaluates to a data object that
has a numeric value equal to the count of the Record objects in the data
object OrderFile.
Note A map rule has a maximum length of 32K characters.
Some example simple expressions are shown in the following table:
Expression This expression uses:
“ABC Company”
a literal
City Field:Record
a data object name
City Field:Record + State
Field:Record + ZipCode
Field:Record
operators (plus signs) and data object
names
UPPERCASE (City
Field:Record)
the UPPERCASE function and a data object
name
RecordMap
(Record:InputFile)
a map name (RecordMap) and data object
names