My Solution To Excel BI's PQ Challenge 77 - Saturday With Power Query

Join me this Saturday, May 27th, to another #SaturdayWithPowerQuery! 🪄🪄🪄

I will share my solution to Excel BI's Power Query Challenge 77, using the Table.TransformRows and Splitter.Split...?

You can find this challenge here:

Chris Webb's blog "Splitting Text By Character Transition In Power BI And Excel Power Query":

Microsoft documentation "Splitter.SplitTextByCharacterTransition":

Hope you will find it useful.

Remember To Subscribe.

#MSExcel #PowerQuery #PowerQueryGirl #SaturdayWithPowerQuery #TableTransformRows #SplitterSplit #Empowered2XL

0:00 Intro
1:39 Explanation of the Challenge
2:32 Understanding the Input Data Structure
4:11 Starting the Solution in Power Query
5:05 Initial Solution Overview
6:01 Using the Splitter.SplitTextByCharacterTransition Function
7:27 Function Syntax Explanation
10:50 Introducing Table.TransformRows Function
13:04 Nested LET Expression for Transformation
15:43 Simplifying the Split Function
17:01 Simplified Approach Demonstration
18:24 Reference to Chris Webb’s Blog for Function Explanation
20:22 Importance of Character Order in Splitting
21:54 Converting Lists to a Table for Further Processing
23:17 Expanding Nested Lists into Rows
24:00 Splitting Columns Based on Character Transition
31:00 See you next time!

Note: Timestamps generated by #ChatGPT

[qasimjan]

Thank you so much Alejandra. I learned so much from you. GOD bless you.

[rrrraaaacccc]

Great Ale 💯👍 solving those challenges...

[roywilson]

Hi Alejansra, thanks for another interesting video. I had never used the before except in the GUI, the way you edited the produced code from it is much more readable for a human and makes much more sense than what Power Query turns out. Definitely going to take a closer look at this function, as I think it could make code more readable and easier to document. Look forward to seeing your next video.

[DinoAMAntunes]

Goor morning Alejandra those challenge are a very good away to practice