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!
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.
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
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
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'.
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
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
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
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.
Sir, plz help, i have to regularly download attachments from email which are pw protected PDf and I know the Pw too. Even I hav able to open those Pdf and save as Microsoft print Pdf option with the help of Chatgpt VBA code. And thereafter regulator process of ETL. BUT, sir firvi mujhe lagta hai that u can solve it within power query.... Bcom student, 1998 batch, programming zero knowledge, plz guide me to deal with this procedure. Thank you.
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.
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
Nice sir love frome uttarkand 😊😊
Thanks Negi sahab
Your teaching method is very simple and powerful.
Thanks Sanju
Good evening very hard working sir keep it up
Good night satish Ji.. Thanks for your appreciation
Really u r different from other excel youtuber . 100% Clear . different way of explain
Thanks for this valuable appreciation ❤️❤️🙏
Excellent work. I have been looking for it for past so many months.
❤️👍
Dil se thanks. And appreciate your working
A man of par excellence... No words to praise you...
Thanks Zahoor..Happy learning..God bless you ❤️🙏
Brilliant Guruji 🙏 You're my Inspiration
Thanks dear..Really means. A lot to me
I had no idea what you said throughout. Followed the steps, then boom! Thank you!
Kindly learn step by step
@@Innozant it was really helpful video. Thanks man
Amazing Sir I learned a lot from watching your videos. You are extremely good.
Thanks Sandeep Ji🙏❤️
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!
Thanks Kazi sahab❤️🙏
Great Sir, Great, Excellent. Baht acca hai.
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.
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
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
Thanks Jayanta..Hope you like and learn from there...Happy learning..God bless you dear.
Very nice sir and helpful
Thanks Tariq sahab
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'.
thanks all video superbs
Loved it thanks bro
Love you sir🙏🙏🙏🙏🙏🙏
thanks Chaudhary sahab
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
Very good.
Thanks Aqeel sahab
Very very useful
Thanks Dear
Amazing new topic i like it thanks sir u r great
Thanks Kishor ji..Happy learning dear.
Sir, "morning shift' se 'Morning updated sheet' jo add kia, usme duplication ni hoga?
AMazing sir , Thank u
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
Sir,you are great
Thanks Ajay ji
can we make a pivot table from the folder if save here multiple sheet.
Thank you sir.
Thanks Abhishek ji
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
Could you please show how to consolidate different worksheets of 12 monthly GSTR-2B data in a yearly Workbook?
Thanks sir ji
Thanks dear🙏❤️
Thank you
Sir , can we automatically add the data if new excel is added in folder ?
Nice sir👍... If in one workbook have multiple sheet then how to merge multiple workbook with sheets...
Check out the Power query playlist video it is there I think.
Hello , how to connect with you for some professional help and assigns. Thanks
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
Thanks alot made it very easy was trying since a long time 😛
Thanks Meher..Keep learning..Keep exploring ❤️
Sir, can u pl share me the power pivot and power querry links where all video are in series
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.
Sir is it mandatory that all sheet should have same number of column
No it's not mandatory
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
Thanks So Much , Very well explained !!!! ,Can I DM you
Yes you may connect
What if same error occurs while importing from pdf file. Plz provide formula of power query to merge pdf
Sir , do you give certification of excel
Yes dear
Please share the download link for MS Office 2019 and above
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?
if the files are more than 500 then whats the pocess to merge or append?
how to replace value a column where half of the column _Shift and _shift Sir
Sir, plz help, i have to regularly download attachments from email which are pw protected PDf and I know the Pw too.
Even I hav able to open those Pdf and save as Microsoft print Pdf option with the help of Chatgpt VBA code.
And thereafter regulator process of ETL.
BUT, sir firvi mujhe lagta hai that u can solve it within power query....
Bcom student, 1998 batch, programming zero knowledge, plz guide me to deal with this procedure. Thank you.
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.
Sir apki practice file me sort ka file ni khul raha
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
Same problem with me also..... Have you got any solution? Plz do reply
Location exact hogi tu zaror hoga.
POWER Query connection create kar deta h or fail jab hi hota h jub data source nh mita.
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
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
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
Sir practice files link not working
Master assignment link se kar lijiye download .Video Description me available h
Get data ka option ni hai mere office excel me
Which version of excel you are using now
2013
🙏🙏
excel.workbook kyu kia samgha nai
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
Error kyu aayega dear
Dear Sir Maximum Data Par
????kitna bhi data le leon koi issue nhi hoga
🙏🙏👍
🙏