I want to create a 3-way match where the invoice, purchase order and delivery order extractors are able to each extract pdfs from their respective folder paths and export the data into my Excel file.
Currently I have built each individual extractor, how do I do ahead to join them together and run with only 1 click? (rather than opening each individual extractor and clicking run) I am also looking into running it as a sequence if possible, perhaps maybe run all invoice first, then PO, then DO. Please advise
One more question, for the Write Range to Excel output, how do I split them so that each different documents go under different columns? e.g. Invoice columns from A1 to A10, PO columns from A11 to A20
and in the write range
you can give the path as
“Directorypath” + Path.GetFileNameWithoutExtension(“YourDocumentPathVariable”) + “_” + Document_Type+ “.xlsx”
This will help you to create separate excel for each type(Invoices,PO)