Forum Discussion
decarsul
Helper V
Helper VPC crashes when doing a left join
Gday all! This week i've been having an issue with a powerquery left join. I have 2 tables, table 1 contains an id that corresponds with a unique id in table 2. Now i want to join just 1 column...
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.
decarsulHelper V
Helper VMaybe we're not understanding. I geuss a better translation would be 'merging'?
The reason i'm doing it in Powerquery is so that i don't have to load the table that contains more data than i need to the model. But i need it to create a unique id so can i can make a relationship to another table.
aj1973
Community Champion
Community ChampionAhh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.