Data Transformation Engine Design Studio Tutorial
Chapter 14 - Detail Records Not Sorted by PO Summary
Design Studio Tutorial
257
To close all the RandomDetails run results
1 With current focus in the Navigator window on the RandomDetails executable
map (map must be selected), from the Map menu, choose Close All Run
Results.
Tip For quick command access, click (View run results) and click (Close all
run results) tools on the toolbar.
The position of the windows associated with map source files is stored in a
mmsname.mopt file. The RandomDetails.mopt file stores the position and run
results window information.
Summary
Randomly ordered detail records were associated with header records by
identifying matching purchase order numbers. The F_MakePO2 functional map
processed the header records in the header file and the detail file.
On the output card of the F_MakePO2 functional map, the map rule for the
Detail called the F_MakeDetail2 functional map.
This nested functional map used the
EXTRACT function to extract records where
the purchase order number in the detail file equaled the purchase order number in
the header record.
Note Close all maps, type trees, and text files.