Data Transformation Engine Design Studio Tutorial

Chapter 14 - Detail Records Not Sorted by PO Using the Map Designer
Design Studio Tutorial
255
For the Detail records in the F_MakePO2 functional map:
♦ Use another functional map call and the
EXTRACT function to create the
F_MakeDetail2 functional map to extract a detail record from the detail file
when the PO# of the detail record is equal to the PO# of the header record.
=F_MakeDetail2 ( EXTRACT ( Detail Record:DetailFile ,
PO# Field:Detail Record:DetailFile = PO# Field:HeaderRecord ) )
♦ Use the Functional Map Wizard to create the F_MakeDetail2 functional map.
F_MakeDetail2 Functional Map
♦ Drag the corresponding input items to create the map rules for the output
items.