Forum Discussion

MwanunduSai's avatar
MwanunduSai
New Member
3 years ago
Solved

PDF to Excel in Power Query automated steps

Apologies as i am new to the community. I have a real head scratcher and any assistance would be well appreciated.    Summary. I have a pdf with 151 (not significant for my initial question) page...
General Comment
Need Help
Tutorial Requests
  • MwanunduSai's avatar
    MwanunduSai
    3 years ago

    I ended up finding it easier to parse the pdf into separate pdfs and then load folder. That way all transformations i did on the sample table were repeated on all tables. I was then able to merge. Was quite a struggle to get there but i made it in the end. 

     

    Thanks for your input.

lbendlin's avatar
lbendlin
Super User
3 years ago

The usual approach would be to generate a list of all pages from the PDF, and then call the web contents function for each page separately, After that you can combine the results into a single result set.

MwanunduSai's avatar
MwanunduSai
New Member
3 years ago

I ended up finding it easier to parse the pdf into separate pdfs and then load folder. That way all transformations i did on the sample table were repeated on all tables. I was then able to merge. Was quite a struggle to get there but i made it in the end. 

 

Thanks for your input.