Comparison of Two Different Excel Files

Build
, ,
#1

Hi All,

  1. How to do comparison between two different excel files by using UIPath Activities ?
  2. How to find Match, Unmatched data in between them ?
  3. Which activities are useful for above conditions ?

FYI,In attachment,both files are different files but for understanding purpose i have merge it.

Thanks in advance.

Comparision of Dump and Header Sheet.xlsx (9.1 KB)

#2

Hi
Kindly have a view on this

Cheers @ajay777daule

#3

This will compare the customer numbers and invoice numbers based on the SR number provided.

The main activity to use is the lookup datatable activity, coupled then with an IF statement to work out if the data matches on specific columns of your choice. To compare additional columns just add another lookup and change the target column, outputting to a new variable appropriately named.

MultipleExcelFiles.zip (10.4 KB)