How to compare both excel sheet. and copy data from one excel sheet to another and write status like as, if we have same data then write "data available" and we have no same data in both excel sheet , then write "new data". and updated in status

Data1.xlsx (8.8 KB)
Master.xlsx (9.0 KB)

in general we do have several options:

  • using join datatable activity
  • LINQ
  • (after preparing dt1 col structure) - Set operations intersect/except

give a try by starting an exploration with Join Data Table

Can u provide a proper solution in .zip file