I want to thank you very much for your videos, I'm not exaggerating but you're leveling up my power query skills. I have used your tips in my day to day tasks and it has affected me greatly so thank you for the information you're offering and please continue 👏👏 if you can talk about performance optimization that would be great
Awesome tutorial on data cleaning with the Table.TransformColumns(). It is absolutely helpful. This one is a follow up. From my point of view, once you pick those inconsistente values on Age and DOJ columns, the next step would be to treat those values, I mean replacing with the correct values rather than dropping them (filtering them out) and avoid losing valuable records. I am trying to figure out the logic to pick up thoses bad values and replace with the correct ones in a dynamic and systematic way, rather picking one by one. Thank you for your valuable and inconditional contribution to the data analyst community.
Your level of teaching are far far beyond normal... I mean it's incredibly amazing how you demonstrate, talk and walk through examples. I wish you keep up this great great work to world community. Thanks a lot again. :)
Thanks to this training, and your other videos, I was revisiting a query I'd built a while ago. I had a column that needed padding "0" added to the column. My current code was: 1. Add new Custom Column (PhoneNumberPadded) with the additional padding 2. Removed the original column (PhoneNumber) 3. Renamed the PhoneNumberPadded to PhoneNumber Now... it's 1 TransformColumns step. Cleaner, easier to understand, less likely to break. Awesome! Many thanks.
In case anyone is trying to do multiple transformations on the same column (i.e. nested functions) you just put the _ underscore & first transformation inside brackets as per normal. Which isn't to take away from a really helpful video which helped me figure it out when the official guide left me without a clue. Thanks Chandeep
We are teaching with videos and kind of books, one day we realize that we must practice every day not to forget. But how, with what? in this moment i’ll see goodly. Its very useful to me, thank you very much 🙏🙏🙏
If you can figure out how to use Table.Transform to merge data from one column into another existing one (while leaving that other column as-is), I'd be interested to see how it's done. From what I can tell, you can only really work with each row value.
@@GoodlyChandeep Good idea! You probably have another way to do it, but I got it work like this: = Table.ReplaceValue(T1,each _[Col3],each _[Col1] & _[Col3],Replacer.ReplaceText,{"Col3"})
Another awesome lesson Chandeep! With each of your videos, you widen my knowledge and understanding of the M language. I was able to take this technique and update some of my queries that previously relied on adding a custom column. Now, using this technique, I can do the transformations directly to the column in question without the need of adding a new column. Brilliant!! I'm curious if this method enhances query performance at all. With fewer applied steps, you might think so. But, maybe the difference is too slight to notice. Still, a great technique to know and use. Many thanks for all the great tutorials and learning resources at Goodly :)) Thumbs up!!
Chandeep, thanks for the easy-to-relate examples and the clear walkthrough. In my scenario, I am trying to take values from another column and apply it to the current column - Say, I have a column called Role and another column called Role Corrections. If there is a value in Role Corrections, I want to take it and apply it to the Role column. When I tried TransformColumn function, I get an error about Field Access on Text, which I interpret to mean that the context for _ is the current column value, whereas I need the row value to get value for the other column - how do I do this? As of now, I added another column and then deleted the original Role column once the update is column and then rename the new column to Role. But it is quite long.
I’m glad for all the cleanup of your messy data! I’ve just started learning PQ and your videos are great! Plus your son is adorable in the DAX short. Lol
wow chandeep so easily you describe and keep engage me all the time ... I didn't get bore for a single second and keep continue for more 20 minutes. hats off dear .. please share you power query journey. as you shared dax 5 books. for power query which course and books you are following
Wow, that last example. I'm having a vision of being able to pull a whole folder of Excel files, go through them one by one and dynamically get a different worksheet from each one based on some conditional logic. Haven't come accross this requirement before, but I know it's possible now.
hi The Problem is you are good in explaining, one thing I like to see is to supply example files not in this one but when you use bigger data another thing this is a good video not in terms of explaining but the subject choosen as I said you vave a very good skill in teaching which is a must for any one who want to teach not every one has but I admit you have it, just keep up on good choosen important subjects both in power query and DAX
Chandeep, another outstanding video. This is the kind of advanced M programming that is hard to find, but so much needed. I have a question about the transformation in your first example, where you basically change the "Age" column to "TRUE" if the age is greater than 10. What if instead of changing the "Age" column, you wanted to change the "FavCol" column, but still based on the age in the "Age" column. So, if "Age" is > 10, then change "FavCol" to "Purple" else leave "FavCol" alone. I have this come up many times and I always have to create a new column, then delete the existing column and rename to new column. Thanks.
Hi, there is a drawback using Table.TransformColumns which is it cannot refer to another column but only the one the you defined. , { {“ColumnA”, /**here is only possible to refer to ColumnA**/ Date.From, type date} }
Great combi of videos!! Question, in a terms of efficiency/process speed of query and loading of data, is this last "trick" good in performance once you loaded FROM FOLDER with like 100k of files, many workbooks and so on? I mean, refreshing can be annoying sometimes...
Excellent explanation, thank you very much. Do you have a demo that shows how to make the Append of several excel files when the column names are not the same in all files?
Chandeep : I have a single column with 4 rows. I need to pick only row 1and 2 in one column and row 3 and 4 in another column. The 4 rows are Origiin,FHR,Destination,SC. Thanks for your help
Paste this query in the advanced editor of a blank query and take a look at the steps. Hopefully this should help. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSK1YlWSgKTyWAyRSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Col = _t]), #"2ColTables" = Table.Transpose(Table.FromList(List.Split(Source[Col], 2), Splitter.SplitByNothing())), #"Added Custom" = Table.AddColumn(#"2ColTables", "Custom", each Table.FromColumns(Record.ToList(_))), #"Removed Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}), #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", Table.ColumnNames(#"Removed Columns"[Custom]{0})) in #"Expanded Custom"
This is great, I have a lot of functions similar to your examples in my dataflow, but have a few questions.... 1. can these query fold or if I use this method will it break query folding? 2. In example two when your writing functions against two columns, if the first function breaks will this cause the second one to break? We can control for this error handling but just thought I'd ask. 3. MissingField.Ignore is a new one for me and I will be using it immediately.
Can I use a condition based on a different column to transform multiple columns like this? eg: need to change value of column1, column2 and column3 to null if the value in ConditionColumn is false
Brilliant function and presentation of examples. Thnak You. Can you write how the use of the T.TC function affects the speed of data processing? Can this function speed up the PQ performance in any case?
Hi Is it possible to use this function in a conditional form? Like from Your example: Table.TransformColumns(sometable,"DOJ", if [FavCol] = "Pink" or [FavCol] = "Red" then [DOJ]=FALSE else [DOJ])
Can we transform column using conditions and values from other column. Like Filling all the nulls in column B with the corresponding values of Column A.
Fabulous! I cannot believe I wasted a year thinking the Table.TransformColumns function was extremely difficult to use writing M code. Thank you so much Chandeep!
Question: at 14:36 when you add the comma to add more to the code, what does "nullable" (i.e., nullable function") mean..? i.e., What is the significance of that part of the code (null or nullable show up in a number of commands)
There are situations where we have to do some transformation on a specific column by creating a custom column. Now, If we are using Table.TransformColumns and our transformations are dependent on other columns then this function falls into an error as soon as we refer to other columns. I think this function doesn't support these transformations that are dependent on other columns. I would like to know if there is a way to transform without creating a custom Column.
I have manual entry database, Each row has its own data type.. How can we do make changes row level data in a single column.. Help me on that.... Thank you
@@GoodlyChandeep Not directly with TrasnformColuns but it´s possible withTransformRows: = Table.FromRecords( Table.TransformRows( TransCol, (r)=>Record.TransformFields(r, {"a", each if r[b]="13205" then "ES" else _}) )) Thanks so much for all the effort with your videos and tutorials !!!!! :-) Of course I´m not the ownwer of the answer I found in stackoverflow here´s bellow the link .. :-)
That was really interesting ,, really liked the last bit on accessing the binary files, One thing, Date.From(_) , I've been using Text.Combine( List.Distinct( List.Transform( [All Rows] [Dates], Text.From) ) ,", " ) and my initial inclination was to use Text.From(_) , which did not work, puzzled. lastly guitar do you have? and like and play?
List.From(_) will work if you combine it with the "each" keyword. So something like this = List.Transform( AList, each Text.From(_) ) It's an old guitar my father bought me when I was in school. I play horribly sometimes :D
I'm one of the employees in our company that are using the Power query in excel, however I'm not that familiar with the M Code. So lucky that I accidentally browse on your video. I was trying to look for M code that can Count number of Rows in certain column that has string or number. By the way, How can I activate those pop up list of M Code in excel power query? I noticed that every time you type in a certain M code, there was a pop up list of code that you can choose. If I can activate that in my Excel Power query, it will be helpful/easy to recognize the code. Hopefully you can provide me this Tip. Thank you so much.
This is very cool, but can you do the same for Table.ReplaceValue? I have column where I need to replace multiple characters but end up repeating Table.ReplaceValue several times.
What if I want to bring the name of the column I'm going to perform the transformation on automatically? As it is being created automatically on a list of columns....I mean pick the first column from that list, then the second etc...but without having to name it?
Hi. Question here pls. How can i push one column value from one table to another column not of same name in other table. Using append in power query it just combines two tables with same column name. I would like to map which column value to go to into another column in anothet table. In simple words mapping of source column to destination column and then append
@@GoodlyChandeep Hi. Thanks for your replay, but I have tables no lists. I have been able to combine two or more queries in a single step with the following instruction : Table.AddColumn(PreviousStep, "NewColumn", each Table.NestedJoin(Table.NestedJoin (PreviousColumnName, {"ColumnID "}, QueryName1, {"ColumnID"}, "NewColumn1", JoinKind.LeftOuter), {" ColumnID "}, QueryName2, {" ColumnID "}, " NewColumn2", JoinKind.LeftOuter). The combination and expansion depends on the number of the month, the previous instruction is for the months of January and February and it works for me for more months. I am missing is to be able in a single step to expand the columns contained in QueryName1 and QueryName2 that are inside the columns "NewColumn1" and "NewColumn2" as tables. Could you help me or tell me how to do it. Thanks
Hello chandeep sir, I try to get data from folder in power bi but there is error showing Dataformaterror: table is not in expected format. All excel files are in 97-2003 excel workbook. Is there any way I can get all data from 97-2003 workbook to in power bi? Thank you sir
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
This channel is so underrated - amazing work, thank you!
you're a wizard! I'm relatively new to PQ but light years ahead of others just by watching your videos. Keep up the great work!
I want to thank you very much for your videos, I'm not exaggerating but you're leveling up my power query skills. I have used your tips in my day to day tasks and it has affected me greatly so thank you for the information you're offering and please continue 👏👏 if you can talk about performance optimization that would be great
Great to hear! I'll try to make a video on Query Diagnostics.
Awesome tutorial on data cleaning with the Table.TransformColumns(). It is absolutely helpful.
This one is a follow up. From my point of view, once you pick those inconsistente values on Age and DOJ columns, the next step would be to treat those values, I mean replacing with the correct values rather than dropping them (filtering them out) and avoid losing valuable records. I am trying to figure out the logic to pick up thoses bad values and replace with the correct ones in a dynamic and systematic way, rather picking one by one.
Thank you for your valuable and inconditional contribution to the data analyst community.
Your level of teaching are far far beyond normal... I mean it's incredibly amazing how you demonstrate, talk and walk through examples. I wish you keep up this great great work to world community. Thanks a lot again. :)
Thanks for your beautiful words Jimmy! 😍
Thanks to this training, and your other videos, I was revisiting a query I'd built a while ago. I had a column that needed padding "0" added to the column. My current code was:
1. Add new Custom Column (PhoneNumberPadded) with the additional padding
2. Removed the original column (PhoneNumber)
3. Renamed the PhoneNumberPadded to PhoneNumber
Now... it's 1 TransformColumns step. Cleaner, easier to understand, less likely to break. Awesome! Many thanks.
In case anyone is trying to do multiple transformations on the same column (i.e. nested functions) you just put the _ underscore & first transformation inside brackets as per normal.
Which isn't to take away from a really helpful video which helped me figure it out when the official guide left me without a clue. Thanks Chandeep
I have been using Power Query for many years but I haven't a chance to take this function into this fascinating next step. Thank you so much!!!!
The way you explained function is splendid. i would love to look forward to learn more functions with same explanation. Thanks for sharing.
We are teaching with videos and kind of books, one day we realize that we must practice every day not to forget. But how, with what? in this moment i’ll see goodly. Its very useful to me, thank you very much 🙏🙏🙏
I can spend all day watching the applications of the functions you explain, very good material, thanks
Glad you like them!
Very nice 👍
I,ve been wondered when i saw Text. Replace.
I put functions into each row with changing of arguments Text. Replace and It was awesome
Crack, te pasaste ameo. . With this superfast video you put in clear very power query concepts. Congrats!
Really helpful. thank you. Nice to be able to compress the number of steps showing
I will definitely use the Excel import tip. Very good! Thanks, Chandeep!
One suggestion for the blog post, the link is to be directly to the topic instead of the front page. Thanks.
Hey, you are a genius!!! I really enjoy your videos. They have given me a new level of understanding of Power BI
You're doing a great job. I found this channel by accident, because I checked out a few others. There is a lot of interesting content here. Thanks!
Glad you found it interesting! 💚
If you can figure out how to use Table.Transform to merge data from one column into another existing one (while leaving that other column as-is), I'd be interested to see how it's done. From what I can tell, you can only really work with each row value.
Yes correct. But there is another replacer function that can do it. I am going to do a video on it
@@GoodlyChandeep
Good idea! You probably have another way to do it, but I got it work like this:
= Table.ReplaceValue(T1,each _[Col3],each _[Col1] & _[Col3],Replacer.ReplaceText,{"Col3"})
Another awesome lesson Chandeep! With each of your videos, you widen my knowledge and understanding of the M language. I was able to take this technique and update some of my queries that previously relied on adding a custom column. Now, using this technique, I can do the transformations directly to the column in question without the need of adding a new column. Brilliant!! I'm curious if this method enhances query performance at all. With fewer applied steps, you might think so. But, maybe the difference is too slight to notice. Still, a great technique to know and use. Many thanks for all the great tutorials and learning resources at Goodly :)) Thumbs up!!
Frankly, I didn't check the query performance.
I am going to be doing a video soon on Query Diagnostics, that should help :)
Chandeep, thanks for the easy-to-relate examples and the clear walkthrough. In my scenario, I am trying to take values from another column and apply it to the current column - Say, I have a column called Role and another column called Role Corrections. If there is a value in Role Corrections, I want to take it and apply it to the Role column. When I tried TransformColumn function, I get an error about Field Access on Text, which I interpret to mean that the context for _ is the current column value, whereas I need the row value to get value for the other column - how do I do this? As of now, I added another column and then deleted the original Role column once the update is column and then rename the new column to Role. But it is quite long.
I’m glad for all the cleanup of your messy data! I’ve just started learning PQ and your videos are great! Plus your son is adorable in the DAX short. Lol
Thank you for your nice words J. S. B.! 💚
How could you think out of box !!! ??? Just great, what else could be said. Please make some more vedieos on power query.
Thank you very much, Chandeep. This explanation of the syntax was extremely helpful. Well done!
Glad it was helpful!
Thank you in advanced....
Please inform me, is your power query course cover such detail and advance topic like this, chandeep?
I think all your other users said enough I agree with all of them, so I will just say thank you and that we appreciate you pal.
Thanks Brother!
Another mind blowing video to watch. Great tips
wow chandeep so easily you describe and keep engage me all the time ... I didn't get bore for a single second and keep continue for more 20 minutes. hats off dear .. please share you power query journey. as you shared dax 5 books. for power query which course and books you are following
Thank you so much 😀
I'll make a video on Power Query resources too!
Wow, that last example. I'm having a vision of being able to pull a whole folder of Excel files, go through them one by one and dynamically get a different worksheet from each one based on some conditional logic. Haven't come accross this requirement before, but I know it's possible now.
Thank you! Hope it Will be helpful 💚
hi The Problem is you are good in explaining, one thing I like to see is to supply example files not in this one but when you use bigger data another thing this is a good video not in terms of explaining but the subject choosen as I said you vave a very good skill in teaching which is a must for any one who want to teach not every one has but I admit you have it, just keep up on good choosen important subjects both in power query and DAX
Chandeep, another outstanding video. This is the kind of advanced M programming that is hard to find, but so much needed. I have a question about the transformation in your first example, where you basically change the "Age" column to "TRUE" if the age is greater than 10. What if instead of changing the "Age" column, you wanted to change the "FavCol" column, but still based on the age in the "Age" column. So, if "Age" is > 10, then change "FavCol" to "Purple" else leave "FavCol" alone. I have this come up many times and I always have to create a new column, then delete the existing column and rename to new column. Thanks.
Hi, there is a drawback using Table.TransformColumns which is it cannot refer to another column but only the one the you defined.
, {
{“ColumnA”, /**here is only possible to refer to ColumnA**/ Date.From, type date}
}
Thanks Chandeep. Clear & Interesting ...as always!!
So nice of you
Thanks for valuable information.
Good learning & trick.
How to transform column by filter the data from other table
Thank you for the great video! Exactly what I was looking for.
Excellent lesson. Thank you very much. :-)
Great combi of videos!! Question, in a terms of efficiency/process speed of query and loading of data, is this last "trick" good in performance once you loaded FROM FOLDER with like 100k of files, many workbooks and so on? I mean, refreshing can be annoying sometimes...
Excellent explanation, thank you very much.
Do you have a demo that shows how to make the Append of several excel files when the column names are not the same in all files?
ua-cam.com/video/mZbD8aduIJU/v-deo.html
See this
Chandeep : I have a single column with 4 rows. I need to pick only row 1and 2 in one column and row 3 and 4 in another column. The 4 rows are Origiin,FHR,Destination,SC. Thanks for your help
Paste this query in the advanced editor of a blank query and take a look at the steps. Hopefully this should help.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSK1YlWSgKTyWAyRSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Col = _t]),
#"2ColTables" = Table.Transpose(Table.FromList(List.Split(Source[Col], 2), Splitter.SplitByNothing())),
#"Added Custom" = Table.AddColumn(#"2ColTables", "Custom", each Table.FromColumns(Record.ToList(_))),
#"Removed Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", Table.ColumnNames(#"Removed Columns"[Custom]{0}))
in
#"Expanded Custom"
Thank you so much! Great Tutorials! You are awesome!
I am very appreciate your video!!! Professonal example and mind set!!!
Glad you like it!
This is great, I have a lot of functions similar to your examples in my dataflow, but have a few questions....
1. can these query fold or if I use this method will it break query folding?
2. In example two when your writing functions against two columns, if the first function breaks will this cause the second one to break? We can control for this error handling but just thought I'd ask.
3. MissingField.Ignore is a new one for me and I will be using it immediately.
Not sure about Query Folding.. didn't test for that.
Yes the query will break unless you've used Missing field.ignore
Can I use a condition based on a different column to transform multiple columns like this? eg: need to change value of column1, column2 and column3 to null if the value in ConditionColumn is false
Brilliant function and presentation of examples. Thnak You.
Can you write how the use of the T.TC function affects the speed of data processing?
Can this function speed up the PQ performance in any case?
Amazing. Thank you for teaching in a so Very easy way.
Glad you like it!
Brilliant Chandeep, thanks so much.
Hi Chandeep, I have a question How to change value in other column Based on a condition of current column..
Cool learning new concepts in pq day by by your videos 👌
I love it and give a good explanation about the M function. Thank you very much 👍👍👍👍👍👍
Glad you liked it!
Great, great and great. You make it look easy, even though it's not. Thanks for sharing Chandeep !
Thanks a lot 😊
Thank you so much for your availability!
Keep helping us with great Power Query tricks.
Stay Tuned 😊
Hi Is it possible to use this function in a conditional form? Like from Your example: Table.TransformColumns(sometable,"DOJ", if [FavCol] = "Pink" or [FavCol] = "Red" then [DOJ]=FALSE else [DOJ])
Can we transform column using conditions and values from other column. Like Filling all the nulls in column B with the corresponding values of Column A.
Fabulous! I cannot believe I wasted a year thinking the Table.TransformColumns function was extremely difficult to use writing M code. Thank you so much Chandeep!
Good teacher using first principles.
Glad you think so!
It was amazing! Thank you for shared.
Glad you like this Orlean!
Question: at 14:36 when you add the comma to add more to the code, what does "nullable" (i.e., nullable function") mean..? i.e., What is the significance of that part of the code (null or nullable show up in a number of commands)
Very Gold explained.Thank very much, so helpful
Glad you like it! 😊
your videos give me the feeling of a box of cookies that self refills overnight, tasting better and better any time you eat them, thanks!
Thanks for your inspiring words
!
Awesome Chandeep 🤩. I've just a short a question : We put the colomn names manually(Hardcoded), How can we make it dynamic ? Thank you so much
See this - ua-cam.com/video/1fn8fXYw6M4/v-deo.html
There are situations where we have to do some transformation on a specific column by creating a custom column.
Now, If we are using Table.TransformColumns and our transformations are dependent on other columns then this function falls into an error as soon as we refer to other columns. I think this function doesn't support these transformations that are dependent on other columns. I would like to know if there is a way to transform without creating a custom Column.
I have manual entry database,
Each row has its own data type.. How can we do make changes row level data in a single column..
Help me on that.... Thank you
A big thumbs up. Thank you bro!
Great explanation! Just a question: is it possible when you transform column a refer to column b? I mean: {“a”, each if [
_]
Unfortunately not! I don't think you can refer to a different column.
@@GoodlyChandeep Not directly with TrasnformColuns but it´s possible withTransformRows:
= Table.FromRecords(
Table.TransformRows(
TransCol,
(r)=>Record.TransformFields(r,
{"a", each if
r[b]="13205"
then "ES" else _})
))
Thanks so much for all the effort with your videos and tutorials !!!!! :-)
Of course I´m not the ownwer of the answer I found in stackoverflow here´s bellow the link .. :-)
Simply Gold!!!
Thank you! 💚
Can you similar for table.add for multiple columns?
Hello goodly, quick question if I buy your dax course, will i get both the old and the updated one or just the most recent ?
Hi Anthony,
You'll get access to the new one too as soon as it is out!
@@GoodlyChandeep thanks 😊
Very useful - thanks!
Very cool. Thanks for sharing 👍
Thanks for watching!
Last wala 10 seconds bahut surprising tha sach me😮😊😊
What are some other Super Functions which you recommend? Thanks
Great video, as always!
That was really interesting ,, really liked the last bit on accessing the binary files,
One thing, Date.From(_) , I've been using
Text.Combine(
List.Distinct(
List.Transform( [All Rows] [Dates], Text.From) ) ,", " )
and my initial inclination was to use Text.From(_) , which did not work, puzzled.
lastly guitar do you have? and like and play?
List.From(_) will work if you combine it with the "each" keyword. So something like this
= List.Transform(
AList,
each Text.From(_)
)
It's an old guitar my father bought me when I was in school. I play horribly sometimes :D
I'm one of the employees in our company that are using the Power query in excel, however I'm not that familiar with the M Code. So lucky that I accidentally browse on your video. I was trying to look for M code that can Count number of Rows in certain column that has string or number. By the way, How can I activate those pop up list of M Code in excel power query? I noticed that every time you type in a certain M code, there was a pop up list of code that you can choose. If I can activate that in my Excel Power query, it will be helpful/easy to recognize the code. Hopefully you can provide me this Tip. Thank you so much.
Just update your Excel ! It should show up
Congratulations!
You are really good!
Thank you so much 😀
The last part was the most awesome 👌
Thanks !
Finished watching
Awsome as usual good job
Great…got the amazing insights
Brilliant, thank you
Hello , can you please help me in BOM explosion using DAX?
This is very cool, but can you do the same for Table.ReplaceValue? I have column where I need to replace multiple characters but end up repeating Table.ReplaceValue several times.
Let me try to make a video on this!
Absolute leader in m power query
Thank you 💚
What if I want to bring the name of the column I'm going to perform the transformation on automatically? As it is being created automatically on a list of columns....I mean pick the first column from that list, then the second etc...but without having to name it?
Watch the advanced solution in this video - ua-cam.com/video/t_PDveh-3Fg/v-deo.html
Hi. Question here pls. How can i push one column value from one table to another column not of same name in other table. Using append in power query it just combines two tables with same column name. I would like to map which column value to go to into another column in anothet table. In simple words mapping of source column to destination column and then append
Can you send me some sample data and explain your problem clearly - goodly.wordpress@gmail.com
hI. May I use Table.ExpandTableColumn with Table.TransformColumns to expand multiple combined queries in a previous step
See this, it is similar to what you're asking - ua-cam.com/video/t_PDveh-3Fg/v-deo.html
@@GoodlyChandeep Hi. Thanks for your replay, but I have tables no lists. I have been able to combine two or more queries in a single step with the following instruction : Table.AddColumn(PreviousStep, "NewColumn", each Table.NestedJoin(Table.NestedJoin (PreviousColumnName, {"ColumnID "}, QueryName1, {"ColumnID"}, "NewColumn1", JoinKind.LeftOuter), {" ColumnID "}, QueryName2, {" ColumnID "}, " NewColumn2", JoinKind.LeftOuter). The combination and expansion depends on the number of the month, the previous instruction is for the months of January and February and it works for me for more months.
I am missing is to be able in a single step to expand the columns contained in QueryName1 and QueryName2 that are inside the columns "NewColumn1" and "NewColumn2" as tables. Could you help me or tell me how to do it. Thanks
how did u trumped-up that, it is so cool
Thx man. You are awesome
Amazing sir😊
Great!
obrigado!
many thanks🙏
Hello chandeep sir,
I try to get data from folder in power bi but there is error showing Dataformaterror: table is not in expected format. All excel files are in 97-2003 excel workbook. Is there any way I can get all data from 97-2003 workbook to in power bi?
Thank you sir
Sir,
Please Upload some more videos on power query
Will Do!
Good one
I have a query for u how can I reach out to u?
Hi how to have training session 1-1 with you
Golden!!
Thanks! 😊
Thanks!
Thanks Chris, it means a lot :)