Append two files data into one file

[LeiCheng]

I have two Excel files, one contains ID No., date, and leave hrs, the second one contains ID No., date, OT hrs. I want to combine them into one by ID No. and date, and result will be ID No., date, leave hrs and OT hrs. I tried each of the join tools, but can not obtain the result. Is there any way to get the result? Thanks!

Excel file oneExcel file twoexpected result

[JosephSerpis · Accepted solution]

Hi @LeiCheng I mocked up a workflow that produces the output you describe. My results differ by 1 results for CN111 Date 04-JUL where the results are joined together. Let me know what you think?

[LeiCheng]

hi @JosephSerpis , I made a mistake of the CN111 Date 04-JUL in the expected result file. Your result is exactly what I want. Really appreciate your help!