|
View previous topic :: View next topic
|
| Author |
Message |
sbalajibe
New User
Joined: 15 Aug 2005
Posts: 62
|
|
|
|
Hi all
i have two files input and reference file. i want to use sort and do the following
if the input record matches with the reference file i want to write into output file the keys are branch and product
if the record not available i want to write into exception file
Input File
| Code: |
Branch Product
1111 NR
1111 RE
1111 PH
2222 NR
3333 NR
4444 RE
|
Reference file:
| Code: |
Branch Product Loan
1111 NR 100
1111 PH 200
2222 NR 300
4444 RE 400
5555 RE 400
|
so output should be
| Code: |
Branch Product Loan
1111 NR 100
1111 PH 200
2222 NR 300
4444 RE 400
|
Exception file:
| Code: |
Branch Product
1111 RE
3333 NR
|
regards
Balaji |
|
| Back to top |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
| Back to top |
|
|
|
|
