Why My Join Is Getting More Records than Expected

[ivyqiu]

Hi, I've getting more records in the output than my input after using JOIN. I've checked the article https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Why-Your-Join-Is-Getting-More-Recor... but it doesn't help in my particular case. 

The input file has 2,523 records (see screenshot 1 below). The output after join has 2,549 records (LEFT 433 records in screenshot 2, plus JOIN 2,116 records in screenshot 3). There's no duplicate records. Why is that and how to fix it? Thanks!

1 - 

2 -  

3 - 

[fmvizcaino]

Hi @ivyqiu ,

Are you removing duplicates before both joins? Both of then are removing duplicates the same way your keys are distributed in the join key fields?

If yes, please share your left and right input and your key fields please? You can remove everything from your datasets, only leave the keys, please.

Best,

Fernando Vizcaino

[ivyqiu]

Hi Fernando,

Please see attached. Note that the Left and Join output doesn't equal to Left Input, but Right and Join output match the Right Input.

Thanks for your help.

Ivy

[fmvizcaino · Accepted solution]

Hi @ivyqiu ,

The problem is in your right input. In order to remove duplicates from your join, you need to remove all ID duplication from this input.

Best,

Fernando Vizcaino