Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join tool

SCK
8 - Asteroid

Hi all, I need help. My number of records in the incoming section of Join tool is more than the combined records of the three outputs of the tool. Could someone please help.

 

Input - Left35Output - Left5
  Output - Join30
Input - Right50Output - Right5
Total85Total40
2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @SCK that usually happens when the field or fields you are joining have more than one join/match. E.g. If input 1 you had Product A then in Input 2 Product A twice the Join tool would in Output Join push the two instances they joined. 

SCK
8 - Asteroid

Thank you @JosephSerpis . I was able to solve it the moment I posted the question, but did not find the option to delete the post Thanks for your help though. Appreciate it.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels