Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Creating the F_MakeSalesRecord Functional Map
Design Studio Tutorial
163
The map rule for the SalesRecord object on the output card is:
=F_MakesSalesRecord (Contact:ContactFile,
LOOKUP (Record:RegionLookupFile,
ZipCode Field:Record:RegionLookupFile =
ZipCode Field:Contact:ContactFile ))
Using the Functional Map Wizard
Use the Functional Map Wizard to create the F_MakeSalesRecord functional map
to use two data sources.
To use the Functional Map Wizard
1 For the SalesRecord executable map, place current focus on the map rule for
the SalesRecord component on the output card.
2 Enter the map rule to generate the F_MakesSalesRecord functional map
using the
LOOKUP function:
=F_MakeSalesRecord (Contact:ContactFile,
LOOKUP (Record:RegionLookupFile,
ZipCode Field:.:RegionLookupFile = ZipCode
Field:.:ContactFile))
3 From the Rules menu, choose Functional Map Wizard.