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.
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
Do you want to get on a zoom?
Sure @MarqueeCrew Sorry I wasn't available last time. Let me know if you are still available for the call and how.