I am trying to create a workflow to pull a set of dates and batches from multiple PDF files. Each file contains a date, and a list of batches (and much more information which I don’t need at this time). I have used the PDF parser to pull the list of batches and the date from a file and append the date to each batch in a table and this works fine when there is a single pdf in the input folder. However, I need to do this with a large set of files and if there are multiple files the PDF parser loads them all at once and outputs the batches and the dates from all the files without keeping them together.
I had hoped to use List Files and Table Row to Variable Loop to work through each file individually, so it would find the date in the file and add this to all the batches in that file before moving on to the next file. The problem is that the PDF parser will only take a folder as a variable and not a single file. Can anyone suggest an alternative?
I’ve been having a look at the Tika Parser, that seems to be able to generate a table with the filename in one column and content in another, which looks great, but I can’t get it to feed into the rest of the workflow, "No Column in spec compatible to “DocumentValue”.
It feeds into Punctuation Erasure, Case Converter, Bag of Words Creator then Term to String which generates a list of all the words in the document, then some Rule-Based Row Filters let me pull out exactly what I want (the batches use a consistent format). This is probably very messy, but it’s my first attempt at reading pdf files and the inputs are in a far from ideal format.
I’ll have a think/play and see if there is a better way to approach the problem.
can you use Strings to Document Node to parse the output into a document which then is compatible with the document nodes you use for cleaning?
By the way I guess you can’t share a workflow sample? It’s easier to help even when it’s dummy data
Unfortunately I can’t share the data, but it is essentially a file with a title including the date and a series of graphs for analysis of each batch. There is a lot of superfluous data in there, but for this process I’m looking to extract the batch numbers and tag them with the date of testing.
Ok, after a little bit of tweaking the Tika Parser did the job. Meant I was able to separately pull all the information out of all the individual files but kept track of the Filepath so the association to the original file was intact, then join them together into a desired output table. The next problem is that it seems the supplier of this data hasn’t always been consistent with their formatting