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
Solved! Go to Solution.
@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