Alteryx query stuck

[Barclaysusercds]

Hi - I made an amendment to my Alteryx query to add another join but when I run it it gets stuck. I have tried running the query three times and it gets stuck at the same place. No error appears. Can anyone tell me what is wrong?

[DylanDowrick]

If you were to sample the datasets heading into the joins, does the end join result match what you would expect? 

I am curious if there are duplicates in the join.

[DanielG]

@Barclaysusercds - if you have a many-to-many relationship between tables you should expect it to balloon like that.  Need to know more about the data coming in.  Are either of the fields truly unique identifiers?

[Barclaysusercds]

Thanks both but I do not understand what you mean. The joins are joining different fields. I have a unique function as well to remove duplicates.

[DanielG · Accepted solution]

@Barclaysusercds -- A many to many relationship is when lets say your left table has the ID#6 occurring 50 times and your right table has the joined field with ID#6 occurring 50 times you will get 2500 results for that ID alone as it matches each row from LEFT table to every row from RIGHT table.  Do a quick summary of the "ID" fields counting the occurrences before the joins (break the joins first so it doesnt get stuck again) and do a join on the IDs from the summaries to see what you are going to get for rows for each ID.  I created a sample to hopefully explain what it is I was tallking about.  Let me know if it makes sense.