Log In
Register
Home
New Member
March 9, 2024
Offline
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
Moderators
January 31, 2022
Offline
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
The following users say thank you to Riny van Eekelen for this useful post:
Alan SidmanPower Query
July 15, 2023
Offline
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]
1 Guest(s)
