Forum Discussion

zhoura345's avatar
zhoura345
Frequent Visitor
2 years ago
Solved

Help with Merging Two Tables to Get Desired Result

I have two datasets (one with 5k+ rows, the other 1k+ rows) already loaded in the Power Query Editor. For simplification here are two sample tables to show what I'm looking to do:    Table 1:  ...
Need Help
zhoura345's avatar
zhoura345
Frequent Visitor
2 years ago

Thank you! This worked very well. If you don't mind me asking, my original dataset has many columns, and they seem to be gone after the GroupBy action. Is there a way to return them back? 

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

at the “Extended” step, you must check all columns