Data Transformation Engine Map Designer Reference Guide

Chapter 7 - Formulating Map Rules Mapping an Input Item to an Output Item
Map Designer Reference Guide
128
If an input type is defined as a decimal number, with no pad character, no
separator, and two decimal places, the following table shows an example of input
and output types of an item type definition.
Property Input Type Output Type
Presentation Decimal Decimal
Separators No Yes
Places > Decimal Min 2 2
Pad > Value (none) 0
Padded to (none) 7
Justify (none) Right
The input data is automatically converted to the format of the output data object.
The output data will be in decimal format, right justified, padded to 7 bytes with a
pad character of 0.
Note An input item mapped to an output item must have the same Item Subclass. For
example, both items must have an Item Subclass = Number or both must have
an Item Subclass = Text. To convert the Item Subclass of an item, use the
conversion functions, such as NUMBERTOTEXT, TEXTTODATE, and so on.
Intermediate Item Conversions
When using an item with an Item Subclass of Number or Date & Time as a
text argument, use the
TEXT function to convert that item to a text form.
Concatenating Text Strings
To concatenate text, use the plus symbol (+) between the objects to be
concatenated.
For example, the output Name Field is defined in the map rule as the input
FirstName Fiel, a space, and then the LastName Field.
=FirstName Field:EmployeeInfo + " " + LastName
Field:EmployeeInfo