Forum Discussion

andersthyme's avatar
andersthyme
New Member
4 years ago
Solved

Table based on header from multiple PDFs in a folder

Dear all,   I am new to this forum, and therefore apologize in advance if I am missing anything, but I really hope you can assist.   I have a folder with PDF files all containing multiple tables....
  • Anonymous's avatar
    Anonymous
    4 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.