Тёмный

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

Подписаться
Просмотров 37 тыс.
% 812

Append Data from Folder | Combine Multiple Excel Files into One using Power Query
Excel Power Query Playlist Link-ru-vid.com/group/PLmHi7ol7EPSCqpkQ3DdZuBpPHoBWh7caz
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P?usp=sharing
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-excel-video-course/
✅ Mastering Power BI Video Course
www.innozant.com/courses/power-bi-video-course/
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-macro/
✅ Mastering SQL Video Course
www.innozant.com/courses/oracle-sql-video-course/
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-ru-vid.com/group/PLmHi7ol7EPSBRtYFzDE7Yygj-OcPEWaON
Advanced Excel Sorting and Filter-ru-vid.com/group/PLmHi7ol7EPSAKQ6iN-q2Vp_pYfwwymnnW
Subtotal TTC and Data Validation-ru-vid.com/group/PLmHi7ol7EPSAWsrH4MKVz-hmVn3PB2eNV
Excel What if Analysis-ru-vid.com/group/PLmHi7ol7EPSDw_Fh-XirahgsmRMu68cF1
Excel Array and Sumproduct-ru-vid.com/group/PLmHi7ol7EPSAajekuvYlddxY7TnbBUFYQ
Excel Lookup Functions-ru-vid.com/group/PLmHi7ol7EPSDHiNNE4K1dZaDwWOSA0MIA
Excel Pivot Tables-ru-vid.com/group/PLmHi7ol7EPSCcS7mM4xZHIF-tlY8t1s4y
Excel Power Pivot-ru-vid.com/group/PLmHi7ol7EPSAR2Xx8v_t2LkT1tK8pWoxq
Excel Power Query-ru-vid.com/group/PLmHi7ol7EPSCqpkQ3DdZuBpPHoBWh7caz
Excel Chart and Infographics-ru-vid.com/group/PLmHi7ol7EPSBZuwkzOSSBF08zZ_47Hu4L
Excel Dashboard & Reports-ru-vid.com/group/PLmHi7ol7EPSCpMEou9dXWLwxQ97dnwetu
Value add-ons Playlist
ProQuest-Check Point-ru-vid.com/group/PLmHi7ol7EPSDNDv9bq4saxGTUCoI4jQ_N
Career Guide:सिफर से सिखर तक -ru-vid.com/group/PLmHi7ol7EPSDti8xotPBO8fTILiimoyv_
StudsTalk -The Journey begins-ru-vid.com/group/PLmHi7ol7EPSArIJxvglRNO6OcW-AsF2Vv
QUIZ Sunday-ru-vid.com/group/PLmHi7ol7EPSB3jMr-khvTiYO323Di1-B7
Excel Tips and Tricks-ru-vid.com/group/PLmHi7ol7EPSB4nAmO7jx_zdHJoJ4gv7a6
MIS Interview Cracker-ru-vid.com/group/PLmHi7ol7EPSAWZZhpr7JuqsVc0v1joK8G
MIS Job Live Interview :Based on Real Incident-ru-vid.com/group/PLmHi7ol7EPSDCEnoTzpix72Z61WmXOn4Q
Excel Maharaj-ru-vid.com/group/PLmHi7ol7EPSC1Ptn5KRxxSfP4O7U-u728
Microsoft Powerpoint-ru-vid.com/group/PLmHi7ol7EPSBkszK01vauI-qpIVLefw4D
Microsoft Word-ru-vid.com/group/PLmHi7ol7EPSAHDdSsTgi7100R5T0Qr6NT
Office 365-ru-vid.com/group/PLmHi7ol7EPSCO-7t3hae-wqKSay9NDMkj
Google Sheets-ru-vid.com/group/PLmHi7ol7EPSD9IuLtelWwnUinCxXh7HhG
Microsoft Outlook-ru-vid.com/group/PLmHi7ol7EPSBV7oBgMy1oGyvZ_e3H0t0K
Power BI-ru-vid.com/group/PLmHi7ol7EPSD4w75NdgqHYd4zlqqZnibH
Excel VBA-ru-vid.com/group/PLmHi7ol7EPSC51dg_ZA7rykF8J4nfKKD_
TezXL Jata Shorts-ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RN_zBzpmn2E.html
Announcements-ru-vid.com/group/PLmHi7ol7EPSCwEZ8VqMC6nZeAOCVC2Yqg
Website - "www.innozant.com"
Let's Connect:
Instagram ► innozantinfotech
Facebook ► innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #powerqueryappend#innozant #getandtransformexcel

Опубликовано:

 

27 апр 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 96   
@sanjugalande
@sanjugalande Год назад
Your teaching method is very simple and powerful.
@Innozant
@Innozant Год назад
Thanks Sanju
@sarojdas08
@sarojdas08 3 года назад
Really u r different from other excel youtuber . 100% Clear . different way of explain
@Innozant
@Innozant 3 года назад
Thanks for this valuable appreciation ❤️❤️🙏
@rkrajeev2357
@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
@navedzone0056 Год назад
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
@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
@Innozant 3 года назад
Thanks Kazi sahab❤️🙏
@robinnegiyt2610
@robinnegiyt2610 3 года назад
Nice sir love frome uttarkand 😊😊
@Innozant
@Innozant 3 года назад
Thanks Negi sahab
@zahoorsarbandi2982
@zahoorsarbandi2982 3 года назад
A man of par excellence... No words to praise you...
@Innozant
@Innozant 3 года назад
Thanks Zahoor..Happy learning..God bless you ❤️🙏
@satishojha6240
@satishojha6240 3 года назад
Good evening very hard working sir keep it up
@Innozant
@Innozant 3 года назад
Good night satish Ji.. Thanks for your appreciation
@oladimejiojo5787
@oladimejiojo5787 2 года назад
I had no idea what you said throughout. Followed the steps, then boom! Thank you!
@Innozant
@Innozant 2 года назад
Kindly learn step by step
@oladimejiojo5787
@oladimejiojo5787 2 года назад
@@Innozant it was really helpful video. Thanks man
@sandeepaswal8944
@sandeepaswal8944 3 года назад
Amazing Sir I learned a lot from watching your videos. You are extremely good.
@Innozant
@Innozant 3 года назад
Thanks Sandeep Ji🙏❤️
@abhinav10x
@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
@mjaved701
@mjaved701 3 года назад
Dil se thanks. And appreciate your working
@rkrajeev2357
@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'.
@arpitcolor
@arpitcolor Год назад
Excellent work. I have been looking for it for past so many months.
@Innozant
@Innozant Год назад
❤️👍
@acommonman155
@acommonman155 Год назад
Brilliant Guruji 🙏 You're my Inspiration
@Innozant
@Innozant Год назад
Thanks dear..Really means. A lot to me
@jayantabhattacharyya628
@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
@Innozant 3 года назад
Thanks Jayanta..Hope you like and learn from there...Happy learning..God bless you dear.
@manjulapapanna5633
@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
@Md.Ismail-v1e
@Md.Ismail-v1e 6 месяцев назад
Great Sir, Great, Excellent. Baht acca hai.
@MsExcelPakistan
@MsExcelPakistan 3 года назад
Very nice sir and helpful
@Innozant
@Innozant 3 года назад
Thanks Tariq sahab
@satyanarayanasharma5199
@satyanarayanasharma5199 5 месяцев назад
Sir , can we automatically add the data if new excel is added in folder ?
@sanjayborah9591
@sanjayborah9591 7 месяцев назад
Sir, "morning shift' se 'Morning updated sheet' jo add kia, usme duplication ni hoga?
@RA-rh5lb
@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
@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
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
thanks all video superbs
@zainulabedin6368
@zainulabedin6368 Год назад
Loved it thanks bro
@debabratakhasnabis6060
@debabratakhasnabis6060 Год назад
Could you please show how to consolidate different worksheets of 12 monthly GSTR-2B data in a yearly Workbook?
@narenderkumararya7498
@narenderkumararya7498 10 месяцев назад
can we make a pivot table from the folder if save here multiple sheet.
@kishorpanara4191
@kishorpanara4191 3 года назад
Amazing new topic i like it thanks sir u r great
@Innozant
@Innozant 3 года назад
Thanks Kishor ji..Happy learning dear.
@nileshchavan742
@nileshchavan742 3 года назад
Nice sir👍... If in one workbook have multiple sheet then how to merge multiple workbook with sheets...
@anirbanmukherjee2590
@anirbanmukherjee2590 3 года назад
Check out the Power query playlist video it is there I think.
@timesavertricks
@timesavertricks 3 месяца назад
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?
@mungarilal1085
@mungarilal1085 7 месяцев назад
Sir is it mandatory that all sheet should have same number of column
@Innozant
@Innozant 7 месяцев назад
No it's not mandatory
@razaawan977
@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
@mayurt4628 Год назад
Hello , how to connect with you for some professional help and assigns. Thanks
@RoyalSDG
@RoyalSDG 8 месяцев назад
What if same error occurs while importing from pdf file. Plz provide formula of power query to merge pdf
@aqeelahmadengr3
@aqeelahmadengr3 3 года назад
Very good.
@Innozant
@Innozant 3 года назад
Thanks Aqeel sahab
@nurulhaque89
@nurulhaque89 3 года назад
Very very useful
@Innozant
@Innozant 3 года назад
Thanks Dear
@aninayan3543
@aninayan3543 2 месяца назад
if the files are more than 500 then whats the pocess to merge or append?
@AL-KAMAL1
@AL-KAMAL1 4 месяца назад
Please share the download link for MS Office 2019 and above
@ifbreports2860
@ifbreports2860 2 года назад
Sir, can u pl share me the power pivot and power querry links where all video are in series
@AjaySeth
@AjaySeth 4 месяца назад
Thanks So Much , Very well explained !!!! ,Can I DM you
@Innozant
@Innozant 4 месяца назад
Yes you may connect
@shrikantbadge3978
@shrikantbadge3978 Год назад
AMazing sir , Thank u
@abhisheksrivastava9377
@abhisheksrivastava9377 2 года назад
Thank you sir.
@Innozant
@Innozant 2 года назад
Thanks Abhishek ji
@himanshu23457
@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
@avinayakchoudhary4172
@avinayakchoudhary4172 3 года назад
Love you sir🙏🙏🙏🙏🙏🙏
@Innozant
@Innozant 3 года назад
thanks Chaudhary sahab
@ajaysaroha2539
@ajaysaroha2539 3 года назад
Sir,you are great
@Innozant
@Innozant 3 года назад
Thanks Ajay ji
@mahaveerprajapat7094
@mahaveerprajapat7094 2 года назад
Thank you
@meditationmusic6482
@meditationmusic6482 3 года назад
Thanks sir ji
@Innozant
@Innozant 3 года назад
Thanks dear🙏❤️
@kalpanaghongade8890
@kalpanaghongade8890 2 года назад
Sir , do you give certification of excel
@Innozant
@Innozant 2 года назад
Yes dear
@arshadalam6109
@arshadalam6109 4 месяца назад
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
@Simmuandeku
@Simmuandeku 2 года назад
Thanks alot made it very easy was trying since a long time 😛
@Innozant
@Innozant 2 года назад
Thanks Meher..Keep learning..Keep exploring ❤️
@pratyushrautray3916
@pratyushrautray3916 3 года назад
how to replace value a column where half of the column _Shift and _shift Sir
@sakshamdhiman565
@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
@ghumansaab2314
@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
@vasimuddinsheikh3766 3 года назад
Same problem with me also..... Have you got any solution? Plz do reply
@muhammadhuzaifa4521
@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
@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
@noorirfan4886
@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
@Innozant 2 года назад
Error kyu aayega dear
@vellamemer5134
@vellamemer5134 2 года назад
Sir apki practice file me sort ka file ni khul raha
@dushyantkaushik5328
@dushyantkaushik5328 Год назад
Sir practice files link not working
@Innozant
@Innozant Год назад
Master assignment link se kar lijiye download .Video Description me available h
@Harish.Prasad.Semwal
@Harish.Prasad.Semwal 7 месяцев назад
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.
@ahphotoworlds404
@ahphotoworlds404 3 года назад
Dear Sir Maximum Data Par
@Innozant
@Innozant 3 года назад
????kitna bhi data le leon koi issue nhi hoga
@ChiragSingh
@ChiragSingh 8 месяцев назад
Get data ka option ni hai mere office excel me
@Innozant
@Innozant 8 месяцев назад
Which version of excel you are using now
@ChiragSingh
@ChiragSingh 8 месяцев назад
2013
@sadashivkage3133
@sadashivkage3133 9 месяцев назад
🙏🙏
@SabkaTau
@SabkaTau 7 месяцев назад
excel.workbook kyu kia samgha nai
@RahulRoy-po9ct
@RahulRoy-po9ct 2 года назад
🙏
@gauravbhatia7987
@gauravbhatia7987 3 года назад
🙏🙏👍