Download Overview - Insight Trader

Transcript
171
If Date Ranges Overlap
It is important to understand that when C and I are merged, if and
where their date ranges overlap, records from I will replace those for
dates that existed originally in file C. Those records in I that do not
have corresponding dates in C will be inserted in their appropriate
positions in F.
To achieve a particular result it is sometimes necessary to delete records from the beginning
or end of one of the two files C and I to remove the overlap and to save them under
temporary names, before undertaking the merging process using these temporary files instead
of the originals.
The Merge Files Dialog Box
After a file has been selected for merging you are presented with the following dialog box:
Fig 7.5
At the top there is a list of the field numbers and corresponding fields for both the current file
and the import file. Below this there two rows of edit boxes - the top one containing the
numbers 2-20 representing the field numbers of the current file. The bottom boxes that are
white need to have inserted the field numbers in the import file that are to replace the
corresponding field numbers of the current file above. This process is repeated for all fields