I'm trying to tie together two data sets with a join tool, but it's only keeping the data where the match rules are met. I'm trying to keep all data from the left data set even if there's not a match. Is there a setting to change this? Would unionizing the left output with the joined output be my best route?
Solved! Go to Solution.
You are correct. A union after the join to bring in the left data would perform a Left Join. The Join output only gives the Inner Join.
I am having this problem too, and using the Union tool did not work. My issue is that on the Left output, it drops those that don't match, and I am not sure why. For instance, 1111 is in the left but not the right. When I do the Join, it completely drops 1111 from everything, and is not in the L output.