Excel comparison and delete unmatch rows

Help Studio
1

Hi,

  1. Read the daily Sheet provided – 3 Records(.i.e Id,Name,Place)
  2. Read the Master Sheet provided – 10 Records (.i.e Id,Name,Place)
  3. Delete the records from the Master sheet, if they are available in the daily sheet.
    Input File:
    image
    image724×525 13.7 KB

    Master File:
    image
    image787×670 20.1 KB
1 Like
2

HI,

How about the following? We can use Except method, in this case.

image
image650×631 14.6 KB 

dtMaster.AsEnumerable.Except(dtInput.AsEnumerable,DataRowComparer.Default).CopyToDataTable

Sample20221130-5.zip (9.3 KB)

Regards,

1 Like
3

@sankar.mayilsamy Check this attached workflow below,
Sankar_ExcelComparison.zip (16.0 KB)

Hope this may help you :slight_smile:

1 Like
4

@sankar.mayilsamy

Please have a look

RemoveMatches_2Col.xaml (10.2 KB)

1 Like