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
What are the Extractors you have used? Have you used 3 different extractors for 3 different types?
For invoice and PO extractor I have used the “invoice” endpoint https://du.uipath.com/ie/invoices
As for DO extractor I used “receipt”
https://du.uipath.com/ie/receipts but it doesn’t seem to be extracting the data well
You can use multiple extractor inside the same Data Extractor Scope Have you tried this?
And in the Configure Extractors for Receipts you can check the Receipts extractors and PO and Invoices you can check the Invoice Extractor
Hope this helps
Thanks so much for your help, I tried this out and it helped me solved this issue. Cheers!
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
You can create new excel itself by following below steps:
Document_type = EachClassifier.DocumentTypeId.Split(".“c)(EachClassifier.DocumentTypeId.Split(”."c).Length - 1).ToString
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)
Hope this helps
Thanks @vinithareddyk123 , will give it a try
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.