Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Creating the RegionReport_SEARCHUP Map
Design Studio Tutorial
169
Creating the RegionReport_SEARCHUP Map
♦ Copy the RegionReport executable map in the Customer.mms map source
file to create the new RegionReport_SEARCHUP executable map.
♦ Modify the input card #2 RegionLookupFile to use the region_asc.txt as the
data source.
♦ Modify the map rule that calls the functional map to use the
SEARCHUP function
instead of
LOOKUP function:
=F_MakeSalesRecord ( Contact:ContactFile ,
SEARCHUP ( Record:RegionLookupFile ,
ZipCode Field:.:RegionLookupFile ,
ZipCode Field:.:ContactFile ) )
Build and run the RegionReport_SEARCHUP map.
The run results are displayed.