Data Transformation Engine Design Studio Tutorial

Chapter 3 - Modifying the Mail.mms Map Source File Entering Map Rules
Design Studio Tutorial
97
10 After the ending parenthesis of the PRESENT function, type a comma (,) and a
space.
Note Underlines in map rules indicate syntax errors. Check the syntax of the map rule if
you see underlines in your map rule.
Mapping the Second Argument of the IF function
The following steps create the second argument of the IF function. The first
argument was the Middle Name Field:ContactsIn, if present. This second
argument is the value of Full Name if a Middle Name is present.
1 Drag First Name Field from the input card into the Rule Bar, after the
command and space just typed.
2 Type + “ ” +
3 Type a space after the plus sign (+).
This space is required.
4 Drag Middle Name Field into the Rule Bar.
5 Type + “. ” +
This period and space provide the literal period (
.) to follow the middle initial
and the space that separates the middle initial from the last name.
6 Type a space after the plus sign (+).
This space is required.
7 Drag Last Name Field into the Rule Bar.