Join outputs don't add up to Inputs

Hello,

I really need your help to guide me on what's wrong with this WF. I'm very new to Alteryx...

The right input total record is 91,903

Left input is 719 records

However:

Total output is only 38 (left output) + 8,412 (join output) + 84,320 (right output)= 92,770 IS NOT EQUAL TO TOTAL INPUT = 91,903 + 719 = 92,622.

148 records are added. Is this weird. I thought whatever comes in will comes out. Please see attached WF.

Thank you so much.

Workflow

Accepted answers

you have duplicate join keys (likely in your right input). You can put a unique tool before the join and check.

cheers,

mark

Thank you for the response @MarqueeCrew but I put unique tools before left input and right input, total output records are still off: See below:

left output: 38

Join: 8,033

Right output: 83,302

Total output: 91,373

VS.

Total inputs: Left: 719 + Right 90,541 = 91,260