Hi all, brand new to power query, been watching lots of tutorials over the last couple days and I feel like I've almost accomplished what I set to do, but I'm stuck just before the end! hopefully someone here can push me across the finish line
The goal was to take one big ugly data dump that is effectively 2 nested tables and try to extract them into 2 individual tables. I've gotten to the point where I can now group the records according to which table they should be in, but I can't figure out how to load them as separate tables?
So right now, i can see my two groups and when I open up the associated tables all looks as it should be (minus a lot of formatting and clean up), but I don't know how to convert or keep each grouping as it's own new independent table, which i'd like to load into the data model... any suggestions? can I split the query here into 2 new queries or something?
The goal was to take one big ugly data dump that is effectively 2 nested tables and try to extract them into 2 individual tables. I've gotten to the point where I can now group the records according to which table they should be in, but I can't figure out how to load them as separate tables?
So right now, i can see my two groups and when I open up the associated tables all looks as it should be (minus a lot of formatting and clean up), but I don't know how to convert or keep each grouping as it's own new independent table, which i'd like to load into the data model... any suggestions? can I split the query here into 2 new queries or something?
Last edited: