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!!!