Data Transformation Engine Design Studio Tutorial
Chapter 6 - Using the OR Function with a Lookup File MakePreferredData Map
Design Studio Tutorial
144
To generate a specific number of occurrences of the Customer group type, you
can index Customer on the output card. When indexed, the object name on the
output card refers to a particular occurrence of that data object. The index of the
occurrence appears in square brackets immediately after its name. After you have
indexed an item output, you can enter a map rule for it.
You need to generate three occurrences of the Customer records in the output of
the MakePreferredData map.
To index the Customer group type
1 On the PreferredFile output card, right-click the Customer(s) group type
and choose Add Index from the context menu.
Another occurrence of the Customer group type appears, followed by the
index number in square brackets [1 ].
2 Index the Customer group type two more times to generate three records.
Creating the Map Rules
Expand each indexed occurrence of the Customer group type to enter the map
rules for each item. Enter
=NONE for the fourth Customer group type.
The data you enter for Company Field/\ID Field/\PurchaseDate Field are:
ABC Co./\35abc/\010322
Sand Inc./\529heu/\000912
Andromeda Co./\577ecc/\010506
Note For each map rule, the expression must start with an equal sign (=).