Hi everyone,
I regularly upload data from PDF reports from a well-known piece of accounting software, which our clients have provided to us.
When the table of data is on a single page of the report, it loads cleanly. However, when I load a table of data, using multiple pages, that crosses over two or more pages of the PDF file, the columns of data become inconsistent when loaded to Power Query.
I've tried cleaning the files in PQ - with no real joy.
Are there any suggestions as to how this can be overcome?
Many thanks
Keith
Hi Keith,
Difficult to say why a PQ doesn't connect well to a PDF without seeing the file. But, as an accountant I wonder why your clients provide data in PDF to begin with. If they use a "well-known piece of accounting software" they surely can provide something in XLSX. That would probably make it a lot easier for you.
Regards,
Riny
Hey Keith, sorry you're having trouble!
Normally I have been able to load multiple sheets using PQ. I do have to make some adjustments with filtering out lines that need to be removed.
I did see what you were talking about just yesterday. Somewhere around the 20th sheet I saw a column shift for no apparent reason. PDF's can really be difficult, so i chalk it up to that. the table isn't well defined. Frankly, I'm surprised it does as well as it does.
Sorry in advance for the redactions.
[Image Can Not Be Found]
[Image Can Not Be Found]
