Remove duplicate in List<System.Data.DataRow>

Remove duplicate in entry only one. I already tried Exists in Collection and List.Contains but seems doesn’t work.

@Jerome_Cabutotan1

Is your input type Datatable ? And do you want to delete duplicate rows from this Datatable ?

1 Like

Correct. What im trying to do is identify this duplicate entries by storing to List.

@Jerome_Cabutotan1

If you want to delete duplicate entries from Datatable then try below expression.

        yourDT.DefaultView.ToTable(True, Column1, column2,..)
1 Like

Hi @Jerome_Cabutotan1

To add to what @lakshman proposed, you can use the filter datatable activity as well to filter the data in the datatable

2 Likes