Hi Everyone,
Greetings!
we are have two files file1 and file2.
Our requirement is to compare these two files and give the below outputs:
If the records match, give the output from file2.
If the records do not match,give the output from file1.
Could you please suggest a way to achieve this.
Retreive reference records from lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Mon Jan 21, 2008 9:35 am
-
- Participant
- Posts: 50
- Joined: Mon Jan 21, 2008 9:35 am
Thank you for immediate reply. Please assume that file1 is source file and file2 is the reference file.the scenario is such that the record may be present in source and reference files as well.this is not the case of missing files.if the record is present in reference file,irrespective of source file, the record should be loaded from reference file.if the record is not available in reference file then only we have to load the file from source.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: