I have a file 'A' with 100 records of customer details with Key as Customer-ID and date.
And i also have two more file 'B' & 'C' with same key (Customer-ID & Date). File B have dept details. And File C have email address details.
I want to put the Salary details from B and email address details in C into the respective feilds in file 'A'
Code: Select all
Code:
FileA:
CustID Date Name Salary Dept Email
001 03191984 Raul REal
001 04191984 Raul REal
001 05191984 Raul REal
002 03191984 Messi FCB
002 05191984 Messi FCB
002 06191984 Messi FCB
Code:
FileB:
Cust-ID Date Salary
001 03191984 5000
002 03191984 6000
Code:
FileC:
Cust-ID Date email
001 03191984 raul@gmail.com
002 03191984 messi@gmail.com
Expected Output:
Code:
FileA:
Cust-ID Date Name Salary Dept Email
001 03191984 Raul 5000 REal raul@gmail.com
001 04191984 Raul 5000 REal raul@gmail.com
001 05191984 Raul 5000 REal raul@gmail.com
002 03191984 Messi 6000 FCB messi@gmail.com
002 05191984 Messi 6000 FCB messi@gmail.com
002 06191984 Messi 6000 FCB messi@gmail.com