Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx query stuck

Barclaysusercds
8 - Asteroid

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?

 

Barclaysusercds_0-1686233295300.png

 

4 REPLIES 4
DylanDowrick
8 - Asteroid

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
12 - Quasar

@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
8 - Asteroid

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
12 - Quasar

@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.  

Labels