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

Рет қаралды 34,392

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

@zahoorsarbandi2982 3 жыл бұрын

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

@Innozant 3 жыл бұрын

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

@robinnegiyt2610 3 жыл бұрын

Nice sir love frome uttarkand 😊😊

@Innozant 3 жыл бұрын

Thanks Negi sahab

@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

@mjaved701 3 жыл бұрын

Dil se thanks. And appreciate your working

@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🙏❤️

@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.

@arpitcolor Жыл бұрын

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

@Innozant Жыл бұрын

❤️👍

@satishojha6240 3 жыл бұрын

Good evening very hard working sir keep it up

@Innozant 3 жыл бұрын

Good night satish Ji.. Thanks for your appreciation

@sanjugalande Жыл бұрын

Your teaching method is very simple and powerful.

@Innozant Жыл бұрын

Thanks Sanju

@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 10 ай бұрын

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

@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❤️🙏

@acommonman155 Жыл бұрын

Brilliant Guruji 🙏 You're my Inspiration

@Innozant Жыл бұрын

Thanks dear..Really means. A lot to me

@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'.

@zainulabedin6368 Жыл бұрын

Loved it thanks bro

@rakeshmlearningentertainme6099 2 жыл бұрын

thanks all video superbs

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

Great Sir, Great, Excellent. Baht acca hai.

@MsExcelPakistan 3 жыл бұрын

Very nice sir and helpful

@Innozant 3 жыл бұрын

Thanks Tariq sahab

@kishorpanara4191 3 жыл бұрын

Amazing new topic i like it thanks sir u r great

@Innozant 3 жыл бұрын

Thanks Kishor ji..Happy learning dear.

@abhisheksrivastava9377 2 жыл бұрын

Thank you sir.

@Innozant 2 жыл бұрын

Thanks Abhishek ji

@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

@mahaveerprajapat7094 Жыл бұрын

Thank you

@shrikantbadge3978 Жыл бұрын

AMazing sir , Thank u

@meditationmusic6482 3 жыл бұрын

Thanks sir ji

@Innozant 3 жыл бұрын

Thanks dear🙏❤️

@aqeelahmadengr3 3 жыл бұрын

Very good.

@Innozant 3 жыл бұрын

Thanks Aqeel sahab

@ajaysaroha2539 3 жыл бұрын

Sir,you are great

@Innozant 3 жыл бұрын

Thanks Ajay ji

@nurulhaque89 3 жыл бұрын

Very very useful

@Innozant 3 жыл бұрын

Thanks Dear

@avinayakchoudhary4172 3 жыл бұрын

Love you sir🙏🙏🙏🙏🙏🙏

@Innozant 3 жыл бұрын

thanks Chaudhary sahab

@narenderkumararya7498 7 ай бұрын

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

@RA-rh5lb Жыл бұрын

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

@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

@debabratakhasnabis6060 10 ай бұрын

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

@ifbreports2860 2 жыл бұрын

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

@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

@sanjayborah9591 4 ай бұрын

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

@satyanarayanasharma5199 2 ай бұрын

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

@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.

@timesavertricks 21 күн бұрын

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 6 ай бұрын

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

@Simmuandeku 2 жыл бұрын

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

@Innozant 2 жыл бұрын

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

@pratyushrautray3916 2 жыл бұрын

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

@sadashivkage3133 6 ай бұрын

🙏🙏

@arshadalam6109 2 ай бұрын

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

@mayurt4628 Жыл бұрын

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

@AL-KAMAL1 Ай бұрын

Please share the download link for MS Office 2019 and above

@mungarilal1085 4 ай бұрын

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

@Innozant 4 ай бұрын

No it's not mandatory

@AjaySeth Ай бұрын

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

@Innozant Ай бұрын

Yes you may connect

@kalpanaghongade8890 2 жыл бұрын

Sir , do you give certification of excel

@Innozant 2 жыл бұрын

Yes dear

@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.

@himanshu23457 2 жыл бұрын

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

@gauravbhatia7987 3 жыл бұрын

🙏🙏👍

@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.

@vellamemer5134 2 жыл бұрын

Sir apki practice file me sort ka file ni khul raha

@sakshamdhiman565 Жыл бұрын

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

@dushyantkaushik5328 Жыл бұрын

Sir practice files link not working

@Innozant Жыл бұрын

Master assignment link se kar lijiye download .Video Description me available h

@ghumansaab2314 3 жыл бұрын

Sir Load karne ke baad jab me data Source me kuch change karta hu to query table me refresh karne par data refresh nai hota na change hota hai

@vasimuddinsheikh3766 2 жыл бұрын

Same problem with me also..... Have you got any solution? Plz do reply

@muhammadhuzaifa4521 Жыл бұрын

Location exact hogi tu zaror hoga. POWER Query connection create kar deta h or fail jab hi hota h jub data source nh mita.

@muhammadhuzaifa4521 Жыл бұрын

File ko connect karny ky bad agr us file me changing karni ho tu change krny k bad Ctrl+S zarort karna. Ok ho jaiga

@ahphotoworlds404 3 жыл бұрын

Dear Sir Maximum Data Par

@Innozant 3 жыл бұрын

????kitna bhi data le leon koi issue nhi hoga

@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