Join tool

[SCK]

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 - Left	35	Output - Left	5
		Output - Join	30
Input - Right	50	Output - Right	5
Total	85	Total	40

[JosephSerpis · Accepted solution]

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]

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.