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:
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.