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!
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!
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🌹👍.
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.
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?
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?
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!
Thank you for making these videos!
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!
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!
@@basensei8699 whatt???/
Excellent.
Great stuff 👌
Nice video, clustered lets are so useful in Power Query
Thanks man! yes i think i'm gonna make a video on Clustered lets by itself.
@@basensei8699 Great idea!
Marvelous 🎉🎉
i want to use merge query if condition achieved how ?
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🌹👍.
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.
@basensei8699hi, this is a great video. Just wanted to see if you made a video on dealing with more than 2 tables..??
I wonder why comments are so few for such videos which are good for learning intricacies of M-language
glorious!
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?
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?
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?
How to load each table as seperate query
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!