Hello! I'm hoping to use PQ to routinely clean up data exports from our acctg software and I'm new to PQ. My challenge - if I export into an excel file, the first row of data is always in the wrong column which creates a problem. I generated the export into pdf format and the result is a multi-page PDF that has identical header information (I'm thinking column names) on each page but there may be no data in an entire column on some of the pages.
When I "Get Data" my options are 16 TABLES and/or 65 PAGES. The later generates 65 different sheets in my workbook - bummer. I assumed the appropriate action was to select all TABLES and launch PQ to clean it up. That brings me to another problem: I've got 16 different queries and the data structure isn't the same for the reason mentioned above (no data in a column on one of many pages of the pdf).
I know I can clean up the excel version of the export and use the resulting file in PQ to do the rest of the "cleanup" but it seems counter-intuitive to do so.
Am I missing something?
I appreciate any direction you can give this newbie.
@kellyferg
I would help if you could upload your exported data. Just what comes out of your accounting system. It doesn't have to be a PDF. Perhaps CSV or TXT.
@Riny - I'm attaching a sample in xls format. We're prompted to generate either pdf or xls files when we initiate an export.
Thank you for any feedback you can provide.
@kellyferg That file isn't very helpful I'm afraid. Reading your question again I note that you are exporting from accounting software. Surely, an accounting package must have the capability to export an XLS(X) file. PDF's are often poorly formatted and give bad results. Are you sure you can't get this in XLSX or CSV?
Yes - that's it. This is a very old software that is used for a small niche (and I'm not a fan). I wanted to try this first but may have to figure out how to pull the data for myself rather than exporting systematically. I waste so much time cleaning up exports, I've got to find a better way.
Thanks again for taking a look!
