Compare and issue a Return code!!!
Posted: Tue May 15, 2012 10:00 pm
Hi Everyone,
My requirement goes this way , Where i will be joining two files and will be sending the data which is matched into one file and other that doesn't match into an another file.I would like to issue a return code of RC4 if the unmatch file contains any data.
Below mentioned were the files:-
File1:-
File2:-
Match file:-
UnMatch file:-
Here i will be joining the two files based on fields present in column1 (TEST) as a key and will be writing the contents that match in both the files into a Match file , and others that doesn't match will be writing the details present in file1 into an UnMatch file , where i would like to issue an RC4 if the UnMatch file contains any data.
Can some one provide me the sort card in achieving the above.
Thanks in advance!!!
My requirement goes this way , Where i will be joining two files and will be sending the data which is matched into one file and other that doesn't match into an another file.I would like to issue a return code of RC4 if the unmatch file contains any data.
Below mentioned were the files:-
File1:-
TEST1 0100
TEST2 0200
TEST3 0300
TEST6 0400
TEST2 0200
TEST3 0300
TEST6 0400
File2:-
TEST1 A123
TEST2 B123
TEST4 C123
TEST5 D123
TEST2 B123
TEST4 C123
TEST5 D123
Match file:-
TEST1 0100 A123
TEST2 0200 B123
TEST2 0200 B123
UnMatch file:-
TEST3 0300
TEST6 0400
TEST6 0400
Here i will be joining the two files based on fields present in column1 (TEST) as a key and will be writing the contents that match in both the files into a Match file , and others that doesn't match will be writing the details present in file1 into an UnMatch file , where i would like to issue an RC4 if the UnMatch file contains any data.
Can some one provide me the sort card in achieving the above.
Thanks in advance!!!