Data Transformation Engine Design Studio Tutorial

Chapter 13 - Mapping Multiple Files to One File Using the Map Designer
Design Studio Tutorial
245
Generating the CreatePO Output
♦ Name output card #1 POOutputFile.
♦ The Type for POOutputFile is File Output Data.
♦ Specify the creation of the F_MakePO functional map on the map rule for the
PO data object. This functional map generates each PO in the output.
The arguments to the F_MakePO functional map are a Header Record, and
the corresponding DetailSet. Pick the DetailSet whose index matches the
Header Record’s index. For example, when Header Record #2 is used, the
CHOOSE function retrieves DetailSet #2 as well.
=F_MakePO (Header Record:HeaderFile, CHOOSE (
DetailSet:DetailFile, INDEX ( Header Record:HeaderFile )))
! Use the
CHOOSE function and the INDEX function to choose the detail set in
the detail file that corresponds with the same header record in the header
file.
♦ Use the Functional Map Wizard to create the F_MakePO functional map.
F_MakePO Functional Map
The F_MakePO functional map has two input cards and one output card, as
specified in the map rule on the PO data object.