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