Excel Power Query Tutorial - Transforming Nested Tables

Transforming nested tables with Excel Power Query is the focus of Part 6 of my Power Query tutorial series. In this video I demonstrate how to use power query nested tables to enhance the power of your data analyses by creating new group-based columns (i.e., "features").
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
Get the Excel workbook used in this video:
💻 github.com/Dav...
-----------------------------------------------------------------------------------------------------------------------
Additional Power Query Tutorial Videos
-----------------------------------------------------------------------------------------------------------------------
What is Excel Power Query AND Why it Matters to You! (Part 1):
📺 • What is Excel Power Qu...
Excel Power Query - Add Column From Examples (Part 2):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Custom Column 1 (Part 3):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Conditional Column (Part 4):
📺 • Excel Power Query Tuto...
Excel Power Query - Grouping Tables of Data (Part 5):
📺 • Excel Power Query Tuto...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video: • Learning R Programming...
Stay healthy and happy data sleuthing!
#ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryNestedTables

[@DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ua-cam.com/video/xIXymabyFIM/v-deo.html

[@panduislami7832]

Excellent, Dave. This is like one hot encoding, correct me if I'm wrong

[@TheHiamet]

This is a beautiful service, David. Thank you for that. This series has been beneficial.

[@eunicen4250]

Great stuff David. You have helped me alot !!!

[@DaveOnData]

Wow! Thank you for the comment. I am happy to hear you've found my content useful.

[@razorscythe7258]

excellent stuff. Please keep posting more

[@DaveOnData]

Thank you for the feedback, will do!

[@dougmphilly]

just discovered your channel love finding new excel tips. subscribed.

[@raraluna306]

on point! looking forward to the next one!

[@DaveOnData]

Thank you for the feedback and so glad you are finding the content useful!

[@betinarubianes2094]

I just wanted to say that I love the content on your channel. You have gained a new subscriber... Thank you! :)

[@controlsgirl]

So awesome following these videos!!!! I love love love it!

[@Data_Mom]

Awesome explanation , especially Pivot Column one. if possible David Langer, one separate video on Pivot/unpivot Columns, I get confused with the topic.

[@DaveOnData]

Thank you for the suggestion, will do. Glad you are finding the series useful!

[@dereckli]

Excellent explanation!

[@guguminhoto]

Awesome video! I’m trying to import a table from the web that has nested table on it, excel even highlights it for me.
Unfortunately excel is not allowing me to click on “expand”. Any idea on why this might be happening? Thank you!!

[@muhammadusman920]

Great

[@DaveOnData]

Thank you for the feedback!

[@AlterAgs]

Boom. Loved it.

[@pillslifestylereviews6714]

8:15 OMG I gotta figure out how to do that in python!

[@VastCNC]

I've been having a problem with nested tables from an OData feed. I have an indicator of month number, year, and company, then the nested table colunn. Filter to the year I need, expand the nested table, load, then None of my expanded data is shown. Just the original filtering columns. I can expand and load a single table, but it breaks with more than one. Scratching my head and digging around when I noticed this.

[@DaveOnData]

Interesting. I must confess that I've never worked with an OData feed - even during my 8 years working at Microsoft. 😲 Maybe a member of the community here has experience working with OData feeds in PQ and can offer assistance.

[@einyv]

So I have a data set trying to match on a huge data on a column I created in each data set. Now in my table where the population is I created 2 column. One for a first pass to find matches and a Second for a second pass. Is there a way to tell power query it it doesn't find a match on the first pass to use the 2nd field instead for the 2nd pass?
If it was SQL I would just join in the lookup source 2x with a condition where it's not found on the first join and encapsulate the column being pulled with isnull(). Does that exist in PQ? For now I created references to the and additional merge query but trying to see if there is a better way.

[@casper3842]

How do you collapse down all the Table and convert to excel again?

[@rrrraaaacccc80]

💯👍