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