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!
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?