Join + Union

jmang128

I am trying to figure out what is up with this union tool which is set to auto configure by name. have been using it for awhile but for some reason it is acting up now. the L input on Join tool is 75,198 and my output on the union tool is 75,202 so I'm not sure why it's seemingly adding 4 rows of data. The L input is where the main data is coming from and R just pulls some qualitative info from Prior month file to add onto current month report. I already made sure there were no duplicates of data in my R input, the prior month file.

OTrieger

It is not enough that R does not have duplications. If you have more output than inputs the Join creating them. What I'm doing when this is happening is adding a RecordID tool before the L Join, then put Unique tool after the J and check which RecordID is duplicated. Or you can do the same with adding the RecordID tool before the R. I does not matter, but it will help you to find the rows that been duplicated.