Power Query - Split Table Dynamically

  Рет қаралды 4,890

BA Sensei

BA Sensei

Күн бұрын

Пікірлер: 21
@Maartenmarsje
@Maartenmarsje 10 ай бұрын
I like how you maneged to learn the M language that well, that you can write the let statements within the steps to combine some logicals steps without throwing errors all the time. Due to your videos, I’m trying to use the ribbon less and less myself. It really works for me to get better at M and improve the endless possiblilities. Thank you for keep making these videos!
@basensei8699
@basensei8699 10 ай бұрын
That's so awesome! thank you ! I find the more one uses m-query instead of the UI the more cool things you can start doing. Basically anything is possible if you know the language!
@tariqaziz4534
@tariqaziz4534 6 ай бұрын
@@basensei8699 whatt???/
@thebhaskarjoshi
@thebhaskarjoshi 10 ай бұрын
Thank you for making these videos!
@jerryboettcher8406
@jerryboettcher8406 6 ай бұрын
Excellent.
@alexrosen8762
@alexrosen8762 10 ай бұрын
Great stuff 👌
@roywilson9580
@roywilson9580 10 ай бұрын
Nice video, clustered lets are so useful in Power Query
@basensei8699
@basensei8699 10 ай бұрын
Thanks man! yes i think i'm gonna make a video on Clustered lets by itself.
@roywilson9580
@roywilson9580 10 ай бұрын
@@basensei8699 Great idea!
@SamehRSameh
@SamehRSameh 10 ай бұрын
Marvelous 🎉🎉 i want to use merge query if condition achieved how ?
@kebincui
@kebincui 10 ай бұрын
hi James. Excellent video as always. I am wondering how you would deal if you have a raw table with more than 2 lines of break (blank) rows. Table.SplitAt function can only split in one location at a time. If you have a solution for such cases, please advise. Thank you🌹👍.
@basensei8699
@basensei8699 10 ай бұрын
thats a great question. the table.splitat function can only split a table into 2. But to overcome this i would do a nested splits over the entire data set. Do the first split. then the second split with have a table that needs to be split more. Then i split that table. and the next one looping through until all ahs been split. This would be a great idea for a future video. I'll make note of this one.
@pradeepthiv2229
@pradeepthiv2229 4 ай бұрын
​@basensei8699hi, this is a great video. Just wanted to see if you made a video on dealing with more than 2 tables..??
@ProfWoW
@ProfWoW 9 ай бұрын
I have a data set that comes in as a notepad single table. I want to dynamically split it into 10+ tables based on their single column titles. Can i repeat the steps in this video to dynamically split 1 table into many?
@ProfWoW
@ProfWoW 9 ай бұрын
I have a large data set that is actually 10 tables that appear to excel as 1 table. Can i dynamically split that table into the 10 tables i need it to be by repeating the steps here 10 times or is there a better way?
@thangvan-h9p
@thangvan-h9p 10 ай бұрын
Hi Bro, if i have a list {18,46,95} , and need to split table at these rows , how we do this? could you please assist?
@bimanroy8865
@bimanroy8865 3 ай бұрын
I wonder why comments are so few for such videos which are good for learning intricacies of M-language
@basensei8699
@basensei8699 3 ай бұрын
glorious!
@hyunjinlee7166
@hyunjinlee7166 6 ай бұрын
I am struggling with SplitAt formula. Everytime I enter the formula, I get an error message "Expression.Error: We cannot convert a value of type Table to type Number. Details: Value=[Table] Type=[Type]" What do I do now? Please help!
@rameshthangaraj6590
@rameshthangaraj6590 3 ай бұрын
How to load each table as seperate query
Power Query - Unstack a Uneven List into a Table 🍔🦖
7:15
BA Sensei
Рет қаралды 1,8 М.
Power Query - Advanced Transformation of Nested Tables
12:37
BA Sensei
Рет қаралды 8 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 27 МЛН
УДИВИЛ ВСЕХ СВОИМ УХОДОМ!😳 #shorts
00:49
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 15 МЛН
APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query
11:53
ِAAA Excel English
Рет қаралды 3,5 М.
Power Query - Unstack Rows with List.Alternate
6:17
BA Sensei
Рет қаралды 3 М.
Power Query - Stacking Horizontal datasets 💀🦙
7:09
BA Sensei
Рет қаралды 1,6 М.
Split by Variable Columns in Power Query
13:38
Goodly
Рет қаралды 30 М.
Power Query - Understanding each and underscore (_)
12:41
BA Sensei
Рет қаралды 7 М.
Power Query - Fixed Pattern Extraction 🎾
8:14
BA Sensei
Рет қаралды 2,2 М.
APQ06: Advanced Power Query Video #6 - M-CODE - Table.Combine
8:22
AAA Excel’s Power
Рет қаралды 6 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 27 МЛН