HI James... Great explanation and very good case study for transforming dirty data in bulks with a custom function. I will download the file and play with it! Thanks
Wonderful - thank you! With every one of your videos I get to add another function to my repertoire - this time it's Text.AfterDelimiter, which will replace a combination of other functions I've been using to achieve the same result.
As usual, awesome video! Could you do this again, but show how to take the original query, add a parameter inside the first "let" statement and have a second "let" statement so that a function could be created directly from the original query - the way Power Query does when you expand tables from a folder using a "Transform" query which can be easily edited to make changes to the "Transform Function"? That would be AWESOME! Thanks again.
@@basensei8699 Thank you James. yes, [] creates a list from column. At 10:01, you specify [[Data]]; I was curious about that specific syntax as opposed to [Data]. I will try to find your source file and play with it :)
Great! Tks to share. I wonder if this would work and how with different files in a directory to replace that “bunch” of auxiliary queries created by power query when it is the case
Thanks for your explanation.
That is VERY impressive
Super Awesome!
Terrific Video!!
thank you!
Thank you James for your dilgent preperation, your amazing easy to folow sample files and your humor. much apreciated :)
Absolutely love all your videos.. most importantly your energy ❤❤❤
HI James... Great explanation and very good case study for transforming dirty data in bulks with a custom function. I will download the file and play with it! Thanks
Your content is OSM in power query👍👍
Thanks a lot 😊
Lots of great tips in one focused example:)
Wonderful - thank you! With every one of your videos I get to add another function to my repertoire - this time it's Text.AfterDelimiter, which will replace a combination of other functions I've been using to achieve the same result.
WOW! Mind blowing! Thanks a lot!
Brilliant as always 👍. Thank you James.
Magistral, genial!.. Amazining... Thanks
As you said, " AMAZINNNG"
Great tutorial. Perfect technique
Thank you! Cheers!
That was great mate thanks 👍
Loved it!
The nested "let" thing is such an improvement over creating separate functions to handle nested table housekeeping.
As usual, awesome video! Could you do this again, but show how to take the original query, add a parameter inside the first "let" statement and have a second "let" statement so that a function could be created directly from the original query - the way Power Query does when you expand tables from a folder using a "Transform" query which can be easily edited to make changes to the "Transform Function"? That would be AWESOME! Thanks again.
Great videos James. Awesome series. Nested tables is def daunting. May I ask why the double square brackets on Data?
[] square brackets when refering to a table creates a list ;)
@@basensei8699 Thank you James. yes, [] creates a list from column. At 10:01, you specify [[Data]]; I was curious about that specific syntax as opposed to [Data]. I will try to find your source file and play with it :)
Magic ✨✨🪄
Great! Tks to share. I wonder if this would work and how with different files in a directory to replace that “bunch” of auxiliary queries created by power query when it is the case
Yes, absolutely
I did it!! Great achievement!