Data Transformation Engine Design Studio Tutorial

Chapter 5 - Using the EXTRACT Function Scenario
Design Studio Tutorial
118
Copies of the files created during the exercises are provided for all chapters in the
Tutorials\Solutions folder. The structure and use of these files is described in
the Design Studio Tutorial Solutions section on page 18.
Scenario
From the FullContact.txt input file, you need to generate a list of labels for the
Florida addresses only.
Extracting Contacts for a Specific State
Modify the ContactToFullLabel map contained in the Mail.mms map source file.
To map the Florida contacts only, use the
EXTRACT function.
Copying the ContactToFullLabel Map
In the Mail.mms map source file, copy the map ContactToFullLabel to a new
name, FloridaLabels.
To copy the ContactToFullLabel map
1 Open the Mail.mms map source file.
2 Make the ContactToFullLabel map the active map by selecting it in the
Navigator.
Note The title bar displays the name of the active map.
3 From the Map menu, choose Copy to copy the ContactToFullLabel map to
the FloridaLabels map.
Tip In the Copy as field, enter FloridaLabels as the name of the new map.