Duplicate value in a colum

Help Activities
, , ,
1

Hi,
I need to check if there are any duplicate values in a column(colB) if there are in need to send a message box displaying the value duplicated.
How do i do that?

2

Hi @RACHEL_PAUL

Duplicate records from the same data table
(From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray).Equals(string.Join(",",p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Try this one
If you want specific Column alone mention the column name
(From p in dt.Select() where( From q in dt.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

3

Whats p and q?

4

@RACHEL_PAUL “p” and “q” are row

5

Hi @RACHEL_PAUL
are you get desirable solution?

1 Like
6

Hello @RACHEL_PAUL

DuplicateValues = YourDatatable.AsEnumerable().Select(Function (a) a.Field(of string)(“yourcolumnname”).ToString).ToArray().GroupBy(Function(x) x).Where(Function(y) y.Count() > 1).ToList()

YourDatatable is the datatable
yourcolumnname is your column name

In the above case you can get duplicates into a list. Or you can watch the below video for datatable based approach.

Thanks

7

Thank you.

8

@RACHEL_PAUL Welcome and Happy Learning

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.