Forum Discussion
Importing PDFs With Structured & Misc Data To Multiple Table (500+ files)
You'll need 4 separate queries, each opening and processing the same file, to produce the 4 different tables you want. In each query go through the processing and transformation steps necessary to get just what you want for that table and delete everything else.
When you've got all of the queries working on 1 file you will probably want to turn the queries into functions. This would allow you to create new queries where you open e.g. a sharepoint folder which holds all of the reports you want to process, and create columns by calling your functions. Again, you would I think need to do this 4 times, one for each table.
Multiple queries was the key (I think), thank you. Having never done it before, I was stuck on going all-in-one so to speak, but I've now got 4 separate queries going that appear to pull the data into 4 separate tabs/tables in excel exactly as I want (3 for 4).
The last one I am trying to transform I have like below, rows 1, 4, and 6 have what I want to be the column headers and rows 2-3, 5, and 7 have the corresponding data that would go in those columns. Still working on that transform and the only issue I see is it appears that when importing, because the text in the "QUALITY CONTROL ACTIONS IMPLEMENTED" section was more than one row of text in the PDF, it didn't just run long in one row but put the wrapped portion on line 2 into another row/cell (hence 2 and 3 instead of just 2). Will need to figure out how to dynamically deal with that with all 3 sections since the notes vary from day to day.
Unfortunately can't share the actual files since they are "technically" sensitive (functionally, not at all) and currently don't have the old template they were using to create these in the first place to make a dummy PDF. Appreciate the input
Hi SCC1990
What is your final output you want, and i have a question that did your title position is fixed? can you provide some more sample data and the output you want so that can provide more suggestion for you.
Best Regards!
Yolo Zhu