Data Transformation Engine Design Studio Tutorial

Chapter 13 - Mapping Multiple Files to One File Using the Map Designer
Design Studio Tutorial
246
For the Header records in the F_MakePO functional map:
♦ Drag the corresponding input data object to create the map rule for
Company Field.
♦ Use text literals to create the label for the PO numbers and drag the
corresponding input data object to create the map rule for PO# Field.
♦ Drag the corresponding input data object to create the map rule for
PODate Field.
For the Detail records in the F_MakePO functional map:
♦ Use another functional map call to create the F_MakeDetail functional map to
get one detail record from the detail set.
=F_MakeDetail ( Detail Record:DetailSet )
♦ Use the Functional Map Wizard to create the F_MakeDetail functional map.