Power Query - Advanced Transformation of Nested Tables

[@thebhaskarjoshi]

Your unique way of teaching M language never fails to amaze me.

[@basensei8699]

thanks man!

[@amitk1208]

Superb ❤

[@mnowako]

WOW! This is much more than amazing! I think one of the best video on the subject. Many thanks!

[@whizzohk]

Pretty powerful stuff indeed! So much more interesting and useful that you didn't just take the easy way. Thank you Sensei!

[@basensei8699]

what a pleasure!

[@larsaustin]

Your channel should have 50x more subscribers at least with the quality of your content. I hope you don’t stop making useful tutorial videos like this.

[@basensei8699]

Glorious thank you!

[@joelabacherli1310]

Absolute master class. This provides so much valuable information. Thank you son much for showing this unique way of transforming tables.

[@basensei8699]

You are very welcome

[@kebincui]

Another excellent video 👍👍 Thank you so much for sharing. It is always enjoyble and beneficial watching your videos. Keep up the good work ❤🌹

[@basensei8699]

Thank you very much!

[@fajnefajne4339]

Wow! So much nice content presented straight to the business. Thank you.❤

[@tterrabend]

I appreciate your “get right to business” method of teaching. This video was mind-blowing! When I navigated to “Like” the video, I discovered I was not yet a subscriber?!?! Oops! I am subscribed now, because I always learn something new from you. Also, I see musical instruments behind you. I’m compelled to support a fellow musician and Power Query teacher-two of my favorite pastimes! Thank you!!

[@basensei8699]

how glorious!

[@jazzista1967]

This is the best example of using very powerful Mcode functions and nested tables in one tutorial... I will download the file and practice. I have several files like this at work and i would like to redo them using these techniques. Thanks

[@basensei8699]

thats so great !

[@nicoogden]

Thank you for this. Super helpful!

[@hatran-ir9ic]

Awesome. You're professional to M code.

[@williamarthur4801]

New viewer / subscriber, loved the use of record, I've always just piled transformations on top of each other, putting them in the form of a record is so much easier to read.

[@basensei8699]

Awesome! Thank you!

[@retamapark]

Thank you! I appreciate the sophisticated example.

[@alexrosen8762]

A great and very useful tutorial 👌

[@kennethstephani692]

Great video!!!

[@aart_analyst]

Brilliant, as usual.

[@larmondoflairallen4705]

That was a wild ride! Awesome!

[@pamphlex]

Thank you, this video has helped me a lot! Those are tricks I use on a regular basis now.

[@basensei8699]

Glad it was helpful!

[@raulparra60]

Otros tutorial muy bueno. Gracias por compartir

[@roywilson9580]

Thanks for another great video. I always prefer to do as much work in the nested tables as possible, it seems quicker and has the great bonus that it dicourages the guys who think they know what they are doing from editing and breaking your query as they see all the brackets and indentations and can't work out what part of the code they want to change.

[@basensei8699]

hahaha i totally do the same thing!

[@roywilson9580]

@@basensei8699 Lol I like to make myself as indispensible as possible!

[@richp2894]

Great video! Thanks for all your content! I've been looking for a way to pull in a value from the 'outer table' into my nested table for hours. All examples seem to have to add a new column to the outer table first. Is there a way to add the "PortfolioAndSource" column in your example directly to the nested table? - Best.

[@FRANKWHITE1996]

power query Genius 😊

[@Imopanemo]

You create such valuable content, and yet have such a low number of subscribers. You are really knowledgeable, maybe for some people you go to fast?!? Anyway, keep up the good work

[@dmclean3324]

pretty cool

[@alejguz1552]

Pretty Good

[@whizzohk]

In that final transformation step to populate Portfolio and Source in the inner table, you did that by adding a column in the outer table. Is it possible to instead use TransformColumns on the outer table, so that you don't need to add a column to it in order to extend the inner table? I had a go at this but I couldn't get the syntax to work as Name.1 and Name were not in scope.

[@basensei8699]

yes this is totally do able!

[@victorsolano9420]

@BA Sensei Great video. Very clear explanation Quick question. Can you take a column from the newly created nested table and transform the column while the table is nested.

[@jimfitch]

Lots of great stuff here. Thank you! Which is more performant: traditional methods (using UI) or nested table transformations?

[@basensei8699]

definitely Nested table transformations!

[@CideeStudio]

thank you

[@SamehRSameh]

Plz need another video use table.transformcolumns & if statement with multiple condition

[@Giridharan952]

Curated and Sharp....

[@harshav107]

Not getting audio, other videos are playing fine

[@bimanroy8865]

I wish PowerQuery had debugging like other programming language

[@냥삼이-m4d]

咋声音都没了呢。。

[@SamehRSameh]

Why you don't use let & in in start but use it in final ??

[@basensei8699]

i want to show there are many ways to do the same thing ;)

[@SamehRSameh]

@@basensei8699 marvelous, plz always give us such these

[@eisaal-binali4968]

how i can contact you , please for any help or for a small project