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