Forum Discussion
editor power query
Hello guys please i need help
i have a PDF file with 568 page each page contient a table. first i convert it into excel file and i didn't get what i want. second i used functionality in excel named data > get data from PDF file and all pages appear on editor power query i remove some columns and use filtre to remove some lines and i got the a perfect result. so the question any one can guide me to applicate it to all tables and extraire result on excel file because it's first time i use 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.
17 Replies
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.
i select the first line so i get all the tables as one source
