Join outputs don't add up to Inputs

[whitesummer]

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.

[MarqueeCrew]

@whitesummer ,

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

 cheers,

 mark

[whitesummer]

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

[MarqueeCrew]

Do you want to get on a zoom?

[whitesummer]

Sure @MarqueeCrew Sorry I wasn't available last time.  Let me know if you are still available for the call and how.