Check for duplicate values present in particular column

Help Studio
, , ,
1

Hi,
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

1 Like
2

Hi,

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)

3

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

4

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 .

2 Likes
5

@vishal_nachankar

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

1 Like