To match and remove duplicate records from two files.
Posted: Fri Feb 06, 2009 1:40 pm
Hello all,
I joined this forum recently.
I had one requirement.
I need to match two files and based on them I had write exception report
1. If the every record in fileA is not present in fileb,
2. if fileb contain any extra records,
3. if fileb contain duplicate records.
For first 2 req. I know I can use "IF MATCH FILEA FILEB"
But how to include 3rd condition with first two.
Please help me.
Regards,
Abhishek.
I joined this forum recently.
I had one requirement.
I need to match two files and based on them I had write exception report
1. If the every record in fileA is not present in fileb,
2. if fileb contain any extra records,
3. if fileb contain duplicate records.
For first 2 req. I know I can use "IF MATCH FILEA FILEB"
But how to include 3rd condition with first two.
Please help me.
Regards,
Abhishek.