32 - Add Column from Examples in Power Query in Excel
ฝัง
- เผยแพร่เมื่อ 13 ต.ค. 2024
- In this video, I will show you how to add a column from example in your data in Power Query editor. In this, you can create a column and enter some text and power query uses that to decipher what you want in the column.
This is similar to the flash fill option we have in Excel that tries to understand the pattern and use it to fill the column
✅ Power Query Course Download files: trumpexcel.com...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #PowerQuery #ExcelTips
How great this option is, so simple and very very under rated. If there were two likes i would shared it. Thanks :)
Column from example option is great, here i can check the function also simultaneously.
Thanks. This is the part I like most in Power Query
Love it. Thanks !
how do I insert manual data entry column in query and it should not go away when I refresh the data set. ? I mean data with respect to the row should present there after refreshing it... Also thanks for this learnings, it really helping me alot
Thanks Trump
Dear TrumpExcel: Thanks for putting out these helpful videos. You make the world a little bit smarter with each one.
I am trying to figure out how to import data from a CSV file, but only some of the headers (columns) based on that the header name is (row 1 is the headers). Also, the header order may change in the sourse.csv file 9out of my control). I've been working my way through the playlist to see if there's an answer here.
Thanks for your VID!! :)
Thanks a lot.
Super feature 👏
Great, Thanks
Nice Osm❤❤❤
great, thanks..
Thank you so much. Your videos as good as donald trump decision
Oof. That's harsh. I don't think the video was that bad
Is this column will be dynamic.
it will be, u could simply check that by adding a new column to the source in your table in excel
This function is not there in my excel
How can power query be so powerful ?? without AI ? can anyone tell about its code ?
Power Query uses M code as it's backend engine. You can check the code for each step when you go the View tab and then click on Advanced Editor. If you're interested in M code, let me know and I can make videos about it
@@trumpexcel Thanks for the reply sir , your videos are rare valuable diamonds on youtube , I am studying excel for deta analytics , I would suggest first make a detail video of benefits of learning M code as a whole . then start the series .
Add column from example option is not showing in my 2016
What can I do
Same here. I have Office 2013
Sir plz change the name Laura with something else... Some time it make us feel like abusive.....