I have two files. For simplicity we will call them A and B. Both have some
key matching variables. Among the key variables in each file, we have a
beginingTime and EndTime. Data layout:
File A: File
Key1 Key2 BeginingTime Endtime PartNum Key1 Key2 BeginningTime
Here is the question: I want to the records where all cases match (easy one).
I also know that there are cases where key1 and key2 in each file match but the
beginingTime in file B as well as the Endtime of B are fully contained in the
beginningTime and Endtime of B. In those cases I want to call it a match also.
By fully contained, I have BeginningTimeB <= BeginningA and EndtimeB <=
My final output will be all the data in B and the PartNum in file A.