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?
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
Great, but Can you build the workflow please
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.
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!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.