PDF File: Import Last Page via PDF

[Pulsar3000]

Hello All:

I have a set of PDF files in a folder with each PDF file with multiple pages/tables.

I would like to automatically select the last table/page without doing so manually for each PDF file via Power Query.

How can I do this?

Thank You!

 

[Matt Allington]

from memory, directionally correct but may not be 100%…
connect to the folder containing the pdfs
do a file combine
when prompted, select any table in the sample file
complete file combine. It will probably error
go back to the sample query and edit it.
delete the selection of any table made previously
get back to a list of all tables in the sample pdf
insert an index column
sort the index column descending
click on the binary for the top table (which is the last table)
edit the code so it doesn’t refer to the hard coded table name. Change it so it refers to the first table. Look for {curly braces} and replace everything inside with 0 indicating the first row
complete any transformation steps
go to the final combine query, delete any failed steps from the bottom, up