Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
290
Views
Topic starter
Hi,
I have a folder of pdfs with tables that I want to extract however each pdf might have 1 page or up to 6-7 apart from the table header the rest just spills into multiple tables is there a way to combine the table into one before combining all the pdfs into one table?
Posted : 15/05/2024 12:09 pm
PDF's are messy. Usually, data is duplicated, what is in Tablexx is also in Pagexx, so you have to filter to get data only from Tables OR pages.
Once you filter the PDF content, you have to create a function to combine data. Normally, each page has a different structure, combining data is not easy.
Posted : 19/05/2024 12:22 am
