Identifying duplicates by comparing two files

Help Studio
, ,
1

Hi Team,

I need help. I am working on with two files. The file from Invoice extracted data and the master file. The problem to solve is

  1. Compare the two files and find
    a - same vendor number, same vendor name but different email id.
    b - same vendor number, same email id but different vendor name

The final data will be exported to new excel file.

Can you please help me with the workflow or .yaml file?Invoice_ext_file.xlsx (267.6 KB) Master.xlsx (9.6 KB)

2

Load both files to DataTable and join them with activity:

Loop over resulting DT to make the checks.

1 Like
3

Thank you @moenk

4

Hi @moenk ,

Thank you for the message. I am new to this uipath. I could create workflow which can identify duplicates. Please find attached but i dont know how to get the

  1. Compare the two files and find
    a - same vendor number, same vendor name but different email id.
    b - same vendor number, same email id but different vendor name

Can you please help with the workflow ?
Identifying mismatch.xaml (7.7 KB) thanks.