Combine Data from Multiple PDFs with Inconsistent Column Names!
ฝัง
- เผยแพร่เมื่อ 23 ก.ย. 2024
- In this video, you will learn how to Merge Data from Multiple PDFs with Inconsistent Column Names. Often, PDFs contain tables with different column names, making it challenging to consolidate the data. This tutorial will show you how to tackle this problem and automate the process of combining data from multiple PDFs across various tables using Power Query.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/h...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers! - วิทยาศาสตร์และเทคโนโลยี
Don't forget to download the file and practice - goodly.co.in/how-to-merge-data-from-multiple-pdfs-inconsistent-columns/
Master 'M' in Power Query - goodly.co.in/learn-m-powerquery/
This is the issue I'm currently encountering and this course is definitely a life-save!!!!!
I was not aware of the meta function. Thank you!!!
Thank you very much for solving this advanced use case! I love writing M code functions as you have shown. Love to see more!
Next level.Making impossible to possible..
As always, thank you Chandeep! The user renaming columns in Excel and then using some PQ dust to dynamically merge columns with similar values is powerfully. Great stuff!
Hi Chandeep, you meta step is phenomenal. This will help me to refer any step from any other query which is just amazing
Thanks for sharing
That's high class Power Query!
Thank you!! I really loved the "Meta" step, I was always searching for this, and now here it is! Every video of yours, i get to learn 😊
Very complex. I've been looking for something like this for ages, but after seeing your video no wonder I couldn't get close to a solution. It's very involved.
This is great. Thank you. I ran into this problem all the time
This is an awesome advanced use case scenario. Love, love, love it.
What can I say a brilliant video, that I can use in my day to day work and improve my queries. ❤.
So awesome, thanks Chandeep
This is great!!! Please do more with PDFs. I beg my Colleagues for csv or excel files. I get no, or at best pdf crystal reports with nested tables and headers. Insight on how to transform PDFs is a game changer!!
Excellent... thanks for sharing 🎉
❤❤❤❤❤❤❤❤❤❤
You are Super awesome Master 🙇♂️
Finally I understood this MetaData concept................................!!!!!!!!!!!!!!
Paay Lagu Sirjee
That was a nice advanced exercise. Good(ly) stuff, right there! ;-)
Wow, this is great....that meta step is phenomenal
Great! 🙏🙏 Thanks for sharing this video
Thanks for sharing Chandeep. I have always enjoyed your video. Mind blowing stuff!
Mind = Blown
Awesome 😎
Simply amazing! Thank you Bro! love it
This was hot stuff. Even your guitar was on fire!
This is so awesome, thanks Chandeep!
simply fantastic
thank you for sharing
🙏
Wow.... Neat!!
Very very useful and well explained 👌
How can I add a column that gives the pdf file name for each line on the table. This is so I can reconcile the data back to the inoives and be sure I'm not missing any files?
Cool, just not forget to tell that numeration in PQ starts with 0. Otherwise, people who are new in PQ will not understand why you use 1 instead 2. But it's a nasty comment, sorry)))
I’m sure that the more advanced users that watch this video know that aspect very well.
and if rows are different? too
why not duplicate the query and remove the last Cols step, does that affect the speed and efficiency?
Duplicating the query means - redoing all the step all over again!
Which means inefficiency
@@GoodlyChandeep okay, thanks for the explanation and I am really grateful to your videos😊
So I have a pdf from print function and it did not give me table data put there is clearly a table on it. So I guess this process won't work for that?
it probably should!
What if my PDF contains different number of pages? Does such solution work dynamically if I have more pages than in the "example file"?
Look at the logic in the video: yes.
THANKSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 😍😍
It is getting lame if I write always the same comments 😂. So here is an issue that I encounter with pdf. Sometimes even though it is a system print out in pdf format the columns are not split in the same way meaning col 17 e. G contains in 9 out of 10 the bank code but in one table it is in Col18. Any idea why this happens?
😮😮😮 wow!
this man is Alien...
🤣
Best intro ever 😂😂😂
👏👏👏👏👏👏👏🙌🙌🙌🙌🙌🙌🙌