hi,
I have two files: File1 and File2
For simplicity i am enclosing the two files showing only two columns SubjectName and Date. In the actual files there are many more columns than just the 2.
Now my goal is to find the matches and non-matches between the two file.
Matches: What defines a match is a follows:
Match-requirement1: If subjectname and date are the same then this is a match.
Match-requirement2: In this requirement we increase the date from "FILE1" by a single day.
File1: SubjectName and (Date+1day) equals SubjectName and Date from File2 then this is a match.
Match-requirement3: In this requirement we decrease the date from "FILE1" by a single day.
File1: SubjectName and (Date-1day) equals SubjectName and Date from File2 then this is a match.
So basically a match is where subjectname and date (within a day of the date from File1) matches with subjectname and date in file2.
So i am not sure how to do this comparison. Originally, i was told to find exact matches between the two files so i concatenated subjname and date and used a dictionary to compare between the two files. However, a new requirement has been added so that a match is anything "within" a day of the date in "File1".
The addition of this new requirement has me a little confused as to what is the best way to handle this.
If anyone can help please let me know.
NOte: Output is put to a worksheet showing the matches between the two files, has subjectname col, date col for file1 and date col for file2 and then another column showing difference in days between the dates between file1 and file2
Bookmarks