Using Join to populate data into column based on match

Question

Hello,

I would like to use a JOIN(or another tool based on this feedback) in my workspace to bring the result in Column G from Data 2 into Column AW in Data 1 matching on Contract ID in both data sets.

I tried using the JOIN tool but the output results are partial, I want to keep ALL DATA rows from DATA 1 and just populate the “Bulk Load Template” in DATA 2 based on the match.

Thank you!!

Adam

BS_THE_ANALYST · Accepted Answer

@Adam_B 
See the 'L' anchor on the righthand side of the Join tool:

This one contains all of the things from Data 1 that didn't match to Data 2!

We then use the Union tool to bring together 1) the things that joined together 2) the things in Data 1 that didn't match to Data 2. Essentially appending them