match fields
Posted: Mon Apr 18, 2005 2:50 pm
Hi,
I have the following requirement :
From a file, if any two or more records have the same value in the customer number field(NUM), but have different values in the accout number(ACC) field then store such records in another file. Problem is that, if the i/p file contains 3 records for the same NUM, and out of the 3, 2 records have same ACC, but the other one has a different one, then all the 3 records should go to the output file.
Right now, I'm able to retrieve either all the records with matching NUM & ACC or those records with matching NUM & different ACC, but not as per the requirement. can someone help me ?
Thanks,
nrc
I have the following requirement :
From a file, if any two or more records have the same value in the customer number field(NUM), but have different values in the accout number(ACC) field then store such records in another file. Problem is that, if the i/p file contains 3 records for the same NUM, and out of the 3, 2 records have same ACC, but the other one has a different one, then all the 3 records should go to the output file.
Right now, I'm able to retrieve either all the records with matching NUM & ACC or those records with matching NUM & different ACC, but not as per the requirement. can someone help me ?
Thanks,
nrc