Compare Two Excel Files and Delete Matching Rows in one excel file

Help Activities
, ,
4

Hi @rsr.chandu

First use read range workbook to read the 2 excels in the datatable dt_ExcelA and dt_ExcelB respectively

Then use assign activity

dt_ExcelB = dt_ExcelB.AsEnumerable().
    Where(Function(rowB) Not dt_ExcelA.AsEnumerable().
    Any(Function(rowA) rowA("Your Value").ToString.Trim = rowB("Invoice Number").ToString.Trim)).
    CopyToDataTable()

Try this
Hope this helps!