Combine Data from Multiple PDFs with Inconsistent Column Names!

Рет қаралды 14,936

Күн бұрын

Пікірлер: 56

@GoodlyChandeep 6 ай бұрын

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/

@Momo_ss31121 3 ай бұрын

This is the issue I'm currently encountering and this course is definitely a life-save!!!!!

@Gorman-84 28 күн бұрын

Highly entertaining! Oh, ya... Educational too as a side benefit. Thanks for all your videos. Very helpful.

@MyAvn Ай бұрын

Thanks

@tak0331 6 ай бұрын

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!

@LakeSightSolutions 6 ай бұрын

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

@eranberl 6 ай бұрын

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

@samsergiesam388 6 ай бұрын

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

@cjimmer4877 6 ай бұрын

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

@aart_analyst 6 ай бұрын

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

@Blueboy30 6 ай бұрын

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.

@DinoDelight 6 ай бұрын

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

@theowemer5782 6 ай бұрын

That's high class Power Query!

@regihamp0206 5 ай бұрын

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

@learningsessions4584 6 ай бұрын

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

@manishdaulat 6 ай бұрын

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 😊

@Nalaka-Wanniarachchi 6 ай бұрын

Next level.Making impossible to possible..

@ourlittlesmarties1188 6 ай бұрын

This is so awesome, thanks Chandeep!

@chrism9037 6 ай бұрын

So awesome, thanks Chandeep

@patrickharilantoraherinjat2994 6 ай бұрын

Simply amazing! Thank you Bro! love it

@arbazahmad7177 6 ай бұрын

Excellent... thanks for sharing 🎉

@debbieashton7654 3 ай бұрын

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?

@lpau6436 2 ай бұрын

Same question for me please. Loving your work 😁

@PowerMacro 6 ай бұрын

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

@gennarocimmino 6 ай бұрын

simply fantastic thank you for sharing 🙏

@RichardJones73 6 ай бұрын

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

@henryseah1162 6 ай бұрын

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

@alexrosen8762 6 ай бұрын

Very very useful and well explained 👌

@seamushand8439 2 ай бұрын

It is indeed Awesome! Thanks

@SantoshBudakoti 6 ай бұрын

Great! 🙏🙏 Thanks for sharing this video

@dirkstaszak4838 5 ай бұрын

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

@virendrasinghrathore5900 6 ай бұрын

Awesome 😎

@GeertDelmulle 6 ай бұрын

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

@Gavsenberg 6 ай бұрын

Mind = Blown

@yousrymaarouf2931 4 күн бұрын

Fantastic

@dirtltd6151 2 ай бұрын

do you have a video that extracts important data from the page? I need an invoice # from one table , the PO # from another, and the data from another, with multiple page PDF's I would like to just get data from Folder and combine this into one table. Is this possible?

@GoodlyChandeep Ай бұрын

it's possible but I don't that specific case as a video:(

@bonmonil 6 ай бұрын

Wow.... Neat!!

@anujshah1236 6 ай бұрын

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

@GoodlyChandeep 6 ай бұрын

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

@anujshah1236 6 ай бұрын

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

@LuisRosa-m7f 6 ай бұрын

and if rows are different? too

@markrsmith5 6 ай бұрын

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

it probably should!

@CiachoAcM 6 ай бұрын

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

Look at the logic in the video: yes.

@ahmesamsaed5961 6 ай бұрын

THANKSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 😍😍

@dimmitrio 6 ай бұрын

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

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

@phillynn5923 6 ай бұрын

Best intro ever 😂😂😂

@dirkstaszak4838 3 ай бұрын

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?