My requirement goes in this way. I need to join two files. Below mentioned were the two input files:-
I need to join two files. Where in the fields in column TEST can act as a key field and it compares the Values present in the NUM column of both the files and value's in the NUM column of File1 should be less than the value in File2 . The output file should contain the records of file1 based on the above conditions.
The fields that meet the above criteria should be of in one file and rest should be in another file.
Can someone provide me the sortcard in achieving the above if possible.
Thanks a lot in advance!!!!!