Check for duplicate values present in particular column

I have datatable
colA colB
abc 123
abc 345

I need to check if the column A has duplicate records in it.If yes it should return me true and also remove the duplicate records from the datatable.

Please anyone can help me on this


Refer to this topic Delete duplicate row based on one column duplicate data

You can remove duplicate row based on colA with assign activity.
(Returns as IEnumerable of DataRow)

i want non of the entry to be present in the datatable

Hi , You can use

Dt1 = dt.DefaultView.ToTable(true, “colB”)

The above expression will give the distinct Rows based on a column . Compare No of rows in DT1 and Dt and if they are equal , we do not have ay duplicate rows.

If the count is not equal , Please loop through the DT1 and use filter wizard to remove the entries .

1 Like


find starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (9.3 KB)