Combine Data from Multiple PDFs with Inconsistent Column Names!

Рет қаралды 9,884

Ай бұрын

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/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step-by-Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/how-to-merge-dat...
===== 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!

Пікірлер: 46

@GoodlyChandeep Ай бұрын

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/

@samsergiesam388 Ай бұрын

Thank you very much for solving this advanced use case! I love writing M code functions as you have shown. Love to see more!

@regihamp0206 25 күн бұрын

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!!

@eranberl Ай бұрын

I was not aware of the meta function. Thank you!!!

@manishdaulat Ай бұрын

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 😊

@aart_analyst Ай бұрын

This is an awesome advanced use case scenario. Love, love, love it.

@cjimmer4877 Ай бұрын

This is great. Thank you. I ran into this problem all the time

@tak0331 Ай бұрын

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!

@patrickharilantoraherinjat2994 Ай бұрын

Simply amazing! Thank you Bro! love it

@Blueboy30 Ай бұрын

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.

@henryseah1162 Ай бұрын

Thanks for sharing Chandeep. I have always enjoyed your video. Mind blowing stuff!

@theowemer5782 Ай бұрын

That's high class Power Query!

@learningsessions4584 Ай бұрын

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

@dirkstaszak4838 13 күн бұрын

What can I say a brilliant video, that I can use in my day to day work and improve my queries. ❤.

@chrism9037 Ай бұрын

So awesome, thanks Chandeep

@GeertDelmulle Ай бұрын

That was a nice advanced exercise. Good(ly) stuff, right there! ;-)

@SantoshBudakoti Ай бұрын

Great! 🙏🙏 Thanks for sharing this video

@arbazahmad7177 Ай бұрын

Excellent... thanks for sharing 🎉

@Nalaka-Wanniarachchi Ай бұрын

Next level.Making impossible to possible..

@PowerMacro Ай бұрын

❤❤❤❤❤❤❤❤❤❤ You are Super awesome Master 🙇‍♂️

@RichardJones73 Ай бұрын

This was hot stuff. Even your guitar was on fire!

@virendrasinghrathore5900 Ай бұрын

Awesome 😎

@LakeSightSolutions Ай бұрын

Finally I understood this MetaData concept................................!!!!!!!!!!!!!! Paay Lagu Sirjee

@Gavsenberg Ай бұрын

Mind = Blown

@DinoDelight Ай бұрын

Wow, this is great....that meta step is phenomenal

@bonmonil Ай бұрын

Wow.... Neat!!

@ourlittlesmarties1188 Ай бұрын

This is so awesome, thanks Chandeep!

@gennarocimmino Ай бұрын

simply fantastic thank you for sharing 🙏

@alexrosen8762 Ай бұрын

Very very useful and well explained 👌

@ahmesamsaed5961 Ай бұрын

THANKSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 😍😍

@nickukragan7228 Ай бұрын

😮😮😮 wow!

@user-zr9zt6gu7d Ай бұрын

and if rows are different? too

@CiachoAcM Ай бұрын

What if my PDF contains different number of pages? Does such solution work dynamically if I have more pages than in the "example file"?

@GeertDelmulle Ай бұрын

Look at the logic in the video: yes.

@markrsmith5 Ай бұрын

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?

@GoodlyChandeep Ай бұрын

it probably should!

@phillynn5923 Ай бұрын

Best intro ever 😂😂😂

@KawanExcel Ай бұрын

this man is Alien...

@GoodlyChandeep Ай бұрын

🤣

@anujshah1236 Ай бұрын

why not duplicate the query and remove the last Cols step, does that affect the speed and efficiency?

@GoodlyChandeep Ай бұрын

Duplicating the query means - redoing all the step all over again! Which means inefficiency

@anujshah1236 Ай бұрын

@@GoodlyChandeep okay, thanks for the explanation and I am really grateful to your videos😊

@jleytonf Ай бұрын

👏👏👏👏👏👏👏🙌🙌🙌🙌🙌🙌🙌

@dimmitrio Ай бұрын

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)))

@GeertDelmulle Ай бұрын

I’m sure that the more advanced users that watch this video know that aspect very well.