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.
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
Thank you James for your dilgent preperation, your amazing easy to folow sample files and your humor. much apreciated :)
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.
Absolutely love all your videos.. most importantly your energy ❤❤❤
Your content is OSM in power query👍👍
Thanks a lot 😊
As you said, " AMAZINNNG"
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.
WOW! Mind blowing! Thanks a lot!
Great tutorial. Perfect technique
Thank you! Cheers!
Magistral, genial!.. Amazining... Thanks
The nested "let" thing is such an improvement over creating separate functions to handle nested table housekeeping.
Loved it!
That was great mate thanks 👍
Lots of great tips in one focused example:)
Brilliant as always 👍. Thank you James.
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!