Forum Discussion
Solved
Appending 419 pages
I have a single pdf report (consisting of 419 pages) that has been imported into PQ and the page appended. 6600 rows and 15 columns. Using Windows 10. Fast processor and 64 mb or ram. Even so, it ...
Hi Robjr Try these please
- Filter pages and columns early in the query to limit data.
- Split the PDF into smaller files, process separately, and append later.
- Use Table.Buffer to reduce repeated data loads:BufferedTable = Table.Buffer(YourTable)
- Simplify the query by removing unnecessary steps and filtering early.
- You could also Pre - Process the pdf using Python or any other compatable tool
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Robjr Try these please
- Filter pages and columns early in the query to limit data.
- Split the PDF into smaller files, process separately, and append later.
- Use Table.Buffer to reduce repeated data loads:BufferedTable = Table.Buffer(YourTable)
- Simplify the query by removing unnecessary steps and filtering early.
- You could also Pre - Process the pdf using Python or any other compatable tool
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Thank you for your sugggestions. I had already incorporated several of them but the Table.Buffer approach was unknown to me. I found a couple of good instructional videos on YouTube (e.g., from APQ16) that guided me through the process.