cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueNote
Frequent Visitor

Getting similarly named tables from PDF files using folder connector

I need to combine multiple similarly structured PDF file tables into one data set. Normally I would just use the Folder connector option from get data however I am having a problem.

The PDF table ID changes from file to file and the auto generated M Code hard codes the table ID as part of it's routine so that it looks for the same table ID in every single file:

 

BlueNote_0-1600448312502.png

BlueNote_1-1600448364277.png

BlueNote_2-1600448434946.png

I am thinking that my M coding skills are just too weak and there must be a solution using some sort of custom M Code for this. I am grateful for any help.

 

The source files are provided to my company from a consultant and they won't give us the backup data so I'd like to use PowerQuery's PDF connector to combine each quarterly file so we can get multiple period reporting and make our own custom reports etc. The data is very confidential so I can't provide the files and I can't make an example file because I don't have the original backup files to generate the PDF.

1 ACCEPTED SOLUTION
Rocco_sprmnt21
Super User
Super User

here

 

could find the tools that solve your problem.

 

try to adapt

 

Table.SelectRows(  source,  each Text.Contains([Name], "(Pag 16-19)")[Data]

 

View solution in original post

1 REPLY 1
Rocco_sprmnt21
Super User
Super User

here

 

could find the tools that solve your problem.

 

try to adapt

 

Table.SelectRows(  source,  each Text.Contains([Name], "(Pag 16-19)")[Data]

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors