Hope you all are well. I need help.
Currently i have a workflow which can extract the information from different invoices and export to a excel file.
What i currently need help is . I have another file with information from the invoices. I need to Compare " Information extracted from Invoice from the workflow" vs the information present in the excel file. Then the bot has to compare these two information and say which ones are duplicate.
I have attached the workflow and the excel file to be compared.
I suppose extracting the text from the other files which are to be matched and storing them into excel and then using remove duplicates function could be much easier.
Thank you for the idea. Can you please help me with modifying in xaml.
Please find attached the file.Multiple_Invoices.xaml (24.2 KB) Report.xlsx (6.9 KB)
Currently i have the file that have 3 invoices details “report.xlsx” provided by you and I need the second file in which the details of invoices are present .
So that i could compare them and look for duplicate values
“I have another file with information from the invoices.”
I need this file for comparing @srinivas_pradeep
I suppose report.xlsx is the file which is the output of your workflow. I Need the second file to which i should comapre report file
one question @nv08 do we need to run it as a separate bot or we can integrate into the main file? i am not sure how do i put it in one workflow. thank you
After your document understanding part report.xlsx file will be generated.
The another file i suppose will be available any time you want (comparison_file.xlsx).
So this solution can be implemented right after the data extraction process in a single main workflow.