Data Transformation Engine Design Studio Tutorial

Chapter 5 - Using the EXTRACT Function Entering a Map Rule to Extract Specific Records
Design Studio Tutorial
122
To use the EXTRACT function in the call to the F_MakeLabels functional map
1 Display the map rule for the Label data object on the FloridaLabelFile output
card.
2 Click in the Rule Bar between the open parenthesis and Contact:ContactFile.
3 Insert the EXTRACT function.
EXTRACT( ) appears in the map rule. The underline in the map rule indicates
a syntax error (the map rule is incomplete, so you can ignore the indicator at
this point).
Since we want to extract from the contact records, the first argument of the
EXTRACT function is the Contact:ContactFile data object.
4 For this reason, delete the close parenthesis before Contact:ContactFile.
5 Type a comma after Contact:ContactFile to enter the second argument of the
EXTRACT function.
6 Drag State Field from the input card into the Rule Bar after the comma.