Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
9 - Comet

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