Splice on duplicate records
Posted: Wed Aug 19, 2009 8:57 am
Hi,
I have 2 files
1st file has the following records:
2nd file has the following records:
The out required is:
Please advise.
Thanks
I have 2 files
1st file has the following records:
User_Id Credit_Type
111111 Visa
111111 Master
222222 Visa
333333 Hugtel
111111 Visa
111111 Master
222222 Visa
333333 Hugtel
2nd file has the following records:
User_Id Name
111111 ABC
222222 CDE
333333 FGH
111111 ABC
222222 CDE
333333 FGH
The out required is:
111111 Visa ABC
111111 Master ABC
222222 Visa CDE
333333 Hugtel FGH
111111 Master ABC
222222 Visa CDE
333333 Hugtel FGH
Please advise.
Thanks