Forum Discussion
Table based on header from multiple PDFs in a folder
- Anonymous4 years ago
Hi andersthyme - I am going to say maybe, but it is very difficult to trouble-shoot in this forum.
To understand the problem, you need to import the PDF files manually to understand the difference between each PDF from in the Advanced Editor screen. Eventually, if you are lucky, a pattern will appear. This pattern can be turned into a Power Query function. The function will open the PDF file, then try to do the conversion. If the first approach (e.g. find table named "X") fails, it tries the second (e.g. find table with field name "abc"), and so on until if reports the PDF as an error.
If possible, please provide a link to one of the PDF's, if data is sensitive then you could recreate a sample PDF or two for us to work with. As Anonymous said, it is difficult to solve this without something to work with.