My requirement goes this way. I would like to add two time fields present in two different files based on join key present in both the files. And would like to move the resultant obtained as per the match keys into an other file and the one that doesn't match with the file2 into one more file. Below mentioned is an example of the same.
Where in the File1 contains the time in 24hr format and File2 just contains only mins and sec's basically the time i.e to be added. The output files should be displayed below.
Can some kindly provide me the sort card in achieving the above.