I know how to import tables from a PDF.
My issue is that some of the pdf files I want to import from may or may not have say Sales data Table and if they do it may not have the same table number or be on a the same page as in the other files.
Can one have Power Query search for a table with a particular heading irrespective as to where it is in the pdf and then import it.
In the attached files I have imported the Sales Table from Report1.pdf but in the second query I manually had to determine which table it was on this occurrence of the Report2.pdf. (It may be that next time Report2 may have a new table inserted above the first table in the report and so the table name will change).
Once I get both tables I then want to merge them.
How can I get PQ to find and import the table I want from each file in a dynamic manner?