Forum Discussion
editor power query
safwen Take the screenshot in your message (see picture) as a starting point.
Klick on the button of the Kind column. Select only "Table" and press OK.
Then in the Data column, press the button with the arrows.
Should look something like this:
Press "Load more" if it show. Now uncheck the box "Use original......" and OK.
That should give you one large table of all the tables combined.
safwen In the Navigator screen you should enable "Select multiple items". That will allow you to select all the tables you need/want.
safwen First you said you had one PDF with 568 pages. Now it seems to connect to Folder containing many PDF's. Don't really understand what you are doing, but perhaps you need to filter the Kind column to show only "Table" and then expand the Data column.
safwen OK, I misunderstood. But what do you want to do next? Combine all in one large table or create separate tables in Excel for every table in the PDF?