How to create 3-way matching with 3 different sequence in only 1 flow chart?

Hi all!

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 :slight_smile:

Best,
Goh

Hi @Goh_Jing_Lun

What are the Extractors you have used? Have you used 3 different extractors for 3 different types?

Hey @vinithareddyk123

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

Hi @Goh_Jing_Lun

You can use multiple extractor inside the same Data Extractor Scope Have you tried this?

image

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

Hey @vinithareddyk123

Thanks so much for your help, I tried this out and it helped me solved this issue. Cheers!

Best,
Goh

1 Like

Hi @vinithareddyk123,

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

Best,
Goh

Hi @Goh_Jing_Lun

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

1 Like

Thanks @vinithareddyk123 , will give it a try :smiley:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.