How to verify a documents based on Excel data?

We have some data in excel file and want to verify documents. Let me Consider and Example: we have data in excel that invoice document is attached. so how to build tha workflow for verifying Whether it is invoice document or not?

Hi

If each of the invoice document has any unique keyword then we can read those pdf and validate as yeah it’s a invoice

So check for those keywords
Read the pdf and see whether It contains that keyword

Cheers @raju_alakuntla

Great, but Can you build the workflow please

Hi,

What you could do is add a column in data sheet that contains unique values pertaining to that invoice only. Next, you only have to compare the two documents based on if that unique value matches the two documents.

@raju_alakuntla Let me Consider and Example: we have data in excel that invoice document is attached ??? It this mean the excel has invoices attached in different rows.

attached pdfs received from mail and want to verify with the key word

@raju_alakuntla Please find the sample workflow below

Example.zip (30.9 KB)

  • Read keywords from the excel and keep it in a data table
  • Read each pdf using Read PDF with text activity
  • Apply regex to check the keyword present or not

I have provided the keyword manually, but in your case you can get from the excel

Note : Install UiPath.PDF.Activities once you open the workflow

Hope this helps!!

Great

Thanks
Raju

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