You can make use of Filter DataTable activity Here as shown below.
one thing that you will have to work here will be on the column types/ format while comparing.
I am facing difficulty in removing duplicate. I am having 30 columns in the excel sheet and if there is a duplicate in a specific column even if other columns are not matching rows should be deleted.
I have used Dt2.DefaultView.ToTable(True,“Column1”) which works to remove duplicates for Column1 as per my requirement but writes back only Column1, other 29 columns are not written back into the sheet
I have used Dt2.DefaultView.ToTable(True,“Column1”,“Column2”,“Column3” …“Column30”) which is removing duplicates for Column1 if the data across all columns are matching and writes back all 30 columns. This is not matching my requirement.