Append Data from Folder | Combine Multiple Excel Files into One using Power Query

Рет қаралды 33,941

3 жыл бұрын

Append Data from Folder | Combine Multiple Excel Files into One using Power Query
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #powerqueryappend#innozant #getandtransformexcel

Пікірлер: 95

@mjaved701 3 жыл бұрын

Dil se thanks. And appreciate your working

@robinnegiyt2610 3 жыл бұрын

Nice sir love frome uttarkand 😊😊

@Innozant 3 жыл бұрын

Thanks Negi sahab

@zahoorsarbandi2982 3 жыл бұрын

A man of par excellence... No words to praise you...

@Innozant 3 жыл бұрын

Thanks Zahoor..Happy learning..God bless you ❤️🙏

@sarojdas08 3 жыл бұрын

Really u r different from other excel youtuber . 100% Clear . different way of explain

@Innozant 3 жыл бұрын

Thanks for this valuable appreciation ❤️❤️🙏

@sandeepaswal8944 3 жыл бұрын

Amazing Sir I learned a lot from watching your videos. You are extremely good.

@Innozant 3 жыл бұрын

Thanks Sandeep Ji🙏❤️

@rakeshmlearningentertainme6099 2 жыл бұрын

thanks all video superbs

@kazisazzad9257 3 жыл бұрын

Thank You, Sir. It has made my life easier. Power Query shows an expression error: "the key didn't match any rows...." Now the problem is solved. I am so happy! Thank you again!

@Innozant 3 жыл бұрын

Thanks Kazi sahab❤️🙏

@arpitcolor Жыл бұрын

Excellent work. I have been looking for it for past so many months.

@Innozant Жыл бұрын

❤️👍

@oladimejiojo5787 2 жыл бұрын

I had no idea what you said throughout. Followed the steps, then boom! Thank you!

@Innozant 2 жыл бұрын

Kindly learn step by step

@oladimejiojo5787 2 жыл бұрын

@@Innozant it was really helpful video. Thanks man

@zainulabedin6368 Жыл бұрын

Loved it thanks bro

@jayantabhattacharyya628 3 жыл бұрын

Dear Sir Superb power query tutorial series. Don't know before that many ways I can append excel data may be different workbooks, worksheets, folder and sub folder. Thanks for uploading such types of informative tutorials. Keep it up. Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 жыл бұрын

Thanks Jayanta..Hope you like and learn from there...Happy learning..God bless you dear.

@acommonman155 Жыл бұрын

Brilliant Guruji 🙏 You're my Inspiration

@Innozant Жыл бұрын

Thanks dear..Really means. A lot to me

@satishojha6240 3 жыл бұрын

Good evening very hard working sir keep it up

@Innozant 3 жыл бұрын

Good night satish Ji.. Thanks for your appreciation

@rkrajeev2357 2 жыл бұрын

Thanks for explaining so well about merging files from different workbooks. Please clarify one aspect mentioned at 3.57 minutes in this video. You said error will occur on merging the files, because - ' names of files are different and the names are not in sequence'. This aspect of names and sequence need to be explained in much more detail. Waiting for your reply.

@navedzone0056 9 ай бұрын

ha yaar bhai thakk gya hoo poora youtube chaan mara liye nahi horha sahi tareeka to pata hai ki kaise hatana hai lekin sala error aaye hi na ye nahi ho paarha hai workbook ka name aur sheet ke bhi name dono same rkh ke bhi dekh liya lekin nahi horha hai pata nahi q

@mahaveerprajapat7094 Жыл бұрын

Thank you

@sanjugalande Жыл бұрын

Your teaching method is very simple and powerful.

@Innozant Жыл бұрын

Thanks Sanju

@user-rm4cg2zn6x 3 ай бұрын

Great Sir, Great, Excellent. Baht acca hai.

@abhisheksrivastava9377 2 жыл бұрын

Thank you sir.

@Innozant 2 жыл бұрын

Thanks Abhishek ji

@shrikantbadge3978 Жыл бұрын

AMazing sir , Thank u

@MsExcelPakistan 3 жыл бұрын

Very nice sir and helpful

@Innozant 3 жыл бұрын

Thanks Tariq sahab

@rkrajeev2357 2 жыл бұрын

Congrats for explaining it so well. At 6.56 minute in this video please explain why column 'Name 1' was chosen and not column 'Name'. Would it make any difference if we choose column 'Name'.

@ajaysaroha2539 3 жыл бұрын

Sir,you are great

@Innozant 3 жыл бұрын

Thanks Ajay ji

@meditationmusic6482 3 жыл бұрын

Thanks sir ji

@Innozant 3 жыл бұрын

Thanks dear🙏❤️

@kishorpanara4191 3 жыл бұрын

Amazing new topic i like it thanks sir u r great

@Innozant 3 жыл бұрын

Thanks Kishor ji..Happy learning dear.

@aqeelahmadengr3 3 жыл бұрын

Very good.

@Innozant 3 жыл бұрын

Thanks Aqeel sahab

@nurulhaque89 3 жыл бұрын

Very very useful

@Innozant 3 жыл бұрын

Thanks Dear

@manjulapapanna5633 2 жыл бұрын

Hi, your videos are helping lot. I am looking hw to merge or rename different headers name from different files into master file in power query. By adding data in reference file all data should reflects in master file.pls advice

@avinayakchoudhary4172 3 жыл бұрын

Love you sir🙏🙏🙏🙏🙏🙏

@Innozant 3 жыл бұрын

thanks Chaudhary sahab

@RA-rh5lb 11 ай бұрын

Thank you Sirji .. Today's takeaway from this lecture is that - 1. Always give the name of your table 2. The file and the sheet name should be the same to avoid errors while merging. my question is how do get back Query settings which mistakenly i closed -which is exist on the right-hand side. if i change the data type to the whole number then the attached decimal would get deleted

@debabratakhasnabis6060 10 ай бұрын

Could you please show how to consolidate different worksheets of 12 monthly GSTR-2B data in a yearly Workbook?

@sanjayborah9591 3 ай бұрын

Sir, "morning shift' se 'Morning updated sheet' jo add kia, usme duplication ni hoga?

@narenderkumararya7498 6 ай бұрын

can we make a pivot table from the folder if save here multiple sheet.

@abhinav10x Жыл бұрын

I am your regular student now, can we creat a Pivot Tables and chart from this Append data, without any problem, as you told that Pivot data should not be in Table format, please guide

@zainulabedin6368 Жыл бұрын

Sir if we have 2 workbook 1 contains shift and product 2nd contains product and shift any solution in making relation ship u mentioned in the video

@Simmuandeku 2 жыл бұрын

Thanks alot made it very easy was trying since a long time 😛

@Innozant 2 жыл бұрын

Thanks Meher..Keep learning..Keep exploring ❤️

@nileshchavan742 3 жыл бұрын

Nice sir👍... If in one workbook have multiple sheet then how to merge multiple workbook with sheets...

@anirbanmukherjee2590 3 жыл бұрын

Check out the Power query playlist video it is there I think.

@ifbreports2860 Жыл бұрын

Sir, can u pl share me the power pivot and power querry links where all video are in series

@satyanarayanasharma5199 Ай бұрын

Sir , can we automatically add the data if new excel is added in folder ?

@timesavertricks 8 күн бұрын

In Power Query when format is selected as Time it makes the time format hh:mm:ss Want to make it into only hh:mm is it possible? if yes then how?

@RoyalSDG 5 ай бұрын

What if same error occurs while importing from pdf file. Plz provide formula of power query to merge pdf

@AL-KAMAL1 Ай бұрын

Please share the download link for MS Office 2019 and above

@pratyushrautray3916 2 жыл бұрын

how to replace value a column where half of the column _Shift and _shift Sir

@sadashivkage3133 6 ай бұрын

🙏🙏

@AjaySeth Ай бұрын

Thanks So Much , Very well explained !!!! ,Can I DM you

@Innozant Ай бұрын

Yes you may connect

@arshadalam6109 Ай бұрын

As per my understanding sheet name and bookname does not matter, yes, all files sheets name must be same to avoid add column step, plz

@Harish.Prasad.Semwal 4 ай бұрын

4:50 : Content column contains Binary Data: We want to get Table Data from Binary Data. So proceed as below: Custom Column Custom Column Formula =Excel.Workbook([Content]) *Content is Available Column Name.

@himanshu23457 Жыл бұрын

Sir ek workbook ke under multiple sheet hai sheet 1 2 3 aur in teno ka data dusari workbook ke under chaheye uska link bhej dijiye

@mungarilal1085 3 ай бұрын

Sir is it mandatory that all sheet should have same number of column

@Innozant 3 ай бұрын

No it's not mandatory

@kalpanaghongade8890 2 жыл бұрын

Sir , do you give certification of excel

@Innozant 2 жыл бұрын

Yes dear

@gauravbhatia7987 3 жыл бұрын

🙏🙏👍

@razaawan977 Жыл бұрын

Hi, i am having a problem, where you deleted all columns except content and name, and then added Merged column, when I add content into Merged then instead of showing table in the column it shows Error. Do you have any email address so I could send you a pictorial view. Thanks you and Keep up the good work.

@mayurt4628 11 ай бұрын

Hello , how to connect with you for some professional help and assigns. Thanks

@vellamemer5134 Жыл бұрын

Sir apki practice file me sort ka file ni khul raha

@sakshamdhiman565 11 ай бұрын

Sir ji meri sheet update nhi ho rhi maine extension bhi check ker liya phir bhi nhi ho rhi Or jo file hai maine usi folder main save kri hai

@noorirfan4886 2 жыл бұрын

Sir evening shift k baad toh general shift aana tha phir error kaise aa gaya wahi Samaj nahi aaya, Aapne bataya sequence mein nahi tha,par woh sequence Kaisa hota Jo error nahi aata

@Innozant 2 жыл бұрын

Error kyu aayega dear