Combine 2 sets of data

Question

I have 2 spreadsheets that I would like to append the columns and align by a unique identifier. Here is an example of the 2 files and the desired output. I tried to us the join but it's not working for me. The join is only returning 2 records that match instead of 5 records with the added columns and information for those names.

File 1               SAMACCOUTName      u12342Bob Jones      u12343Jane Doe      u12344John Smith      u12345Jason Dill      u12346Jill Davis                                      File 2               Domain IDNameStatusDate    u12343Jane DoeHire2/3/2022    u12344John SmithTerminated2/22/2022                                    Output File               SamaccoutNameStatusDate    u12342Bob Jones      u12343Jane DoeHire2/3/2022    u12344John SmithTerminated2/22/2022    u12345Jason Dill      u12346Jill Davis

amruthas2 · Answer

Hi @traceystone

Use join and then union it with the L - 'left unjoined' and J - 'inner join', if you see anything missing from R- 'right joined' you can connect that table aswell with union.

Qiu · Answer

@traceystone 
We can use union the left anchor of the Join tool.

0224-traceystone.yxmd