Excel Compare and Update

Hi Team,

I am having one excel i.e. Name is Master.xlsx which contains the Id and Category. Another excel i.e. Name is - Test.xlsx, contains the Id column.

I wanted to compare the Id from Master excel which Id from Test excel. If Id matches then update Category column from Master excel in Categery column of Test excel againest maching Id.

How I can acheive this. What is the best way. If each file having 1000 records for comparision then how we can do this ?

Please help asap.
Master.xlsx (9.3 KB)
Test.xlsx (9.1 KB)

Compare.xaml (10.8 KB)

1 Like

Hey you can use for each row loop for master data excel and after that you use filter data table and compare master data table id with test table id if filter data table return value more than 1 than use can use if condition and update both table column in inside if condition block