APQ04: Advanced Power Query Video #4 - M-CODE - Combine Inconsistent Tables

[@aniljaggarwal60]

You are sacrificing all the knowledgeable treasure of Excel on the world, in return you will get the love and respect of the world.

[@AAAExcel]

Thank you so much for your nice words, appreciate it

[@kuyakambo2327]

You've explained it far more clearly than the tutorial I've got from Online Courses. Thank you for this awesome video.!!

[@AAAExcel]

happy that you find it useful, please subscribe to the English channel: youtube.com/@aaaexcelenglish

[@agostinhosubtil569]

Another spectacular lesson. Thank you very much for spreading relevant knowledge.

[@AAAExcel]

Most welcome dear 🙏

[@mathsexperts4901]

This channel is the best one I have seen in KZbin, Excellent content, Great work

[@AAAExcel]

Thank you so much 😀

[@davidk919]

Very clear, step by step. Thank you

[@hamvasq]

All great videos! Thank you very much.

[@10ozGold]

Excellent video! Keep up the great work.

[@AAAExcel]

Thank you , happy you like it

[@Hurmali1]

This is excellent, i need to re-visit it a few more times however thank you sir

[@eddieb8337]

Another great lesson...for sure

[@AAAExcel]

thank you

[@anek1945]

Thank you for the excellent material!

[@AAAExcel]

My pleasure

[@zahoorsarbandi2982]

wonderful!.. such issues are usually faced in appending. this video is a complete solution to it.

[@AAAExcel]

Thank you, happy you find it useful 👌

[@DrK99999]

Excellent. Keep it up👌👍

[@AAAExcel]

Thank you 🙏

[@kishorpanara4191]

Wonderful keep it up Thank you dear

[@AAAExcel]

Thank you too

[@jerrydellasala7643]

Great Series! Keep Going!

[@AAAExcel]

Thanks, will do!

[@kebincui]

Wonderful video, keep it up and thank you for sharing💌

[@AAAExcel]

Thank you for your comment, you’re welcome ☺️

[@jawadahmadehssan6251]

Thanks Amr for this wonderful video.

[@AAAExcel]

Glad you liked it! thank you

[@Bhavik_Khatri]

Very nice tutorial 👍

[@AAAExcel]

Thank you 🙏

[@cheikhhakim5864]

Excellent video , thank you sir

[@AAAExcel]

Most welcome 🙏

[@kennethstephani692]

Great video!!

[@AAAExcel]

Thanks!

[@israfilgazi8071]

It really helps me . JAZAKALLAH KHAIR. Thanks a lot.🧡🧡🧡

[@AAAExcel]

Jazak Allah Khair, happy that it was useful

[@michaelaltshuler5810]

Nice job explaining all the details; big help. One issue I am having is when I do the Transform of the data file in addition to the the sheets of the source wokbook, I see a bunch of ExternalData tables which are marked "Hidden". This results in a bunch of undesired rows in my appended worksheet. Where did thes ExternalData sheets come from, and how can I get rid of them? Thank you very much.

[@michaelaltshuler5810]

I should have mentioned that when I examined the source workbook, there are no hidden sheets there.

[@AAAExcel]

My guess is that you have named ranges, tables or print areas, on a separate note, please watch this video, it can achieve the same but much faster and more simple kzbin.info/www/bejne/eGTIlKKNmN98brMsi=3P_KaRc8WtVYXRSt

[@z.719]

Awesome👍

[@AAAExcel]

Thank you 🙏

[@SaleemShouket-r3p]

Great

[@manjeetmarothiya1519]

Thank you so much sir, You explain the List very very Awesome, its so much easy. Thanks for this video. One again sir Thanks.. ❤️❤️

[@AAAExcel]

You are most welcome

[@ExcelInstructor]

@@AAAExcel Hi, I do have a question. why did you overcomplicated that? Here is my code: let Source = Excel.Workbook(File.Contents("C:\Users jpop\Downloads\Different_Column_Tables.xlsx"), true, true)[Data], Custom1 = Table.Combine( Source ) in Custom1 this way there is no need to grab column names separetly, and it will be done automaticly.

[@AAAExcel]

I tried this one, amazing, it’s working perfectly.. thank you 🙏

[@AAAExcel]

If you allow me, I will do a quick video to explain it

[@ExcelInstructor]

@@AAAExcel sure go ahead :) to me thats common knowladge, or maybe im so deep in PQ that this is super obvious to me, I dont know. but anyway, sure make video out of it :) If only I had some1 for video editing. I do love making videos, i hate edditing videos.

[@manjeetmarothiya1519]

Dear Sir please make video on power BI in English Also...

[@AAAExcel]

It will come with the power pivot series. next video will come soon

[@Mohamed-km9jd]

What if i don't want any null value in new column?

[@AAAExcel]

what do you want instead? you can relpace null value with a defalut value if requried

[@mahmoudmhamid5468]

يعطيك العافيه استاذ أنا بشتغل محاسب تكاليف بمطعم و جردت اخر السنه و عملت تسوية جردية للمستودع عشان اثبت الفعلي عملت تسوية مدينه و تسويه دائنه الفعلي طرحت منه المعياري و بعدها خرجت الموجب و أدخلت السالب ع المستودع عشان ما يطلع فرق و فعليا المستودع صار الفروقات فيه صفر لكن ع ميزان المراجعه حساب المخزون كبيرررر يعني ضعف بضاعه اخر المده شو السبب؟

[@AAAExcel]

اهلا بك .. معلش. ايه علاقة السؤال بموضوع الڤيديو؟ هل كنت شغال علي الملفات باستخدام باور كويري او حاجة زي كده؟

[@mahmoudmhamid5468]

اه شغال بور كويري

[@amanijeanpierre7911]

How do I export data with file name using power query for text files.

[@AAAExcel]

You can go to data, get data, from file, from folder, then select the folder contains the text files and click ok The power query will launch and you will a list of all files of the folder

[@amanijeanpierre7911]

@@AAAExcel My point was if I combine binaries (content column) in power query, I don’t want to lose the file name column. I want to extract file name together with content.Remember the source file is a text file or CSV.

[@AAAExcel]

Ok, then you can use add custom columns, in the new column use function “CSV.Document”, then remove all the columns except the file name and new custom column then expand

[@stephenbui490]

I've learning M code by coding :D

[@AAAExcel]

Excellent