Is there a way we can find out duplicate items of a column in datatable without looping it for each row but can be fetched as a list or array or datatable itself w=using one-liner function? Can we use dtTable.Dataview for this ? Any inputs would be appreciated. Thanks!

@Sachingoudar Hi, check this below :point_down: [image] How to get duplicate rows for specific column in a datatable Help HI @Sunitha_Bist1 , Duplicate records from the same data table (From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray…

@mz3bel @arivu96 Thank you for pointing me there. But I am getting this exception with the above expression. Am I missing something here? Datatble testDt= (From p in dt.Select() where( From q in dt.Select() where String.Join(“,”,q.ItemArray).Equals(String.Join(“,”,p.ItemArray)) Select q).ToArray.C…

Dim allDuplicates As List(Of String) = dt.AsEnumerable().GroupBy([Function](dr), dr.Field(Of String)("VMDList")).Where([Function](g), g.Count() > 1).SelectMany([Function](g), g).ToList()

@bcorrea Thanks! This will fetch duplicates of multiple records under column “VMDList” but how do I change this to filter duplicates of just one record?

I dont understand what you ask, do you mean records that appear only 2 times? Or do you want to find duplicates of a particular value only?

Please refer [image] I want to remove duplicate rows from datatable by comparing single column Studio @qbss Lets consider your table as, dtTable First try getting all the duplicate rows, dtDuplicateTable = dtTable.AsEnumerable().GroupBy(Function(dr) dr.Field(Of Stri…

I want to find duplicates of a particular value only.

Hi If we want to find the array of duplicate values from a particular column of a table then In a assign activity List_variable = yourdatatablename.AsEnumerable().Select(Function (a) a.Field(of string)(“yourcolumnname”).ToString).ToArray().GroupBy(Function(x) x).Where(Function(y) y.Count() > 1).T…

would be easier to just filter for it then…

@Palaniyappan Thanks! I think its just another form of above expression? My Q here is how to filter duplicate records of an employee from an Employee datable where EmployeId= 1.

Finding duplicate items in a datatable

Help Studio

Madhavi (K) March 19, 2020, 7:46pm 7

Please refer

Topic		Replies	Views
How to get duplicate rows for specific column in a datatable Help datatable	3	10489	March 27, 2018
Select Duplicates in a DataTable Studio datatable	13	1285	December 16, 2021
Duplicate value in a colum Activities datatable , excel , activities , studio	7	974	September 30, 2022
How to find duplicate value in a particular column of a datatable Studio studio , question , activities-panel	10	4618	September 19, 2023
DataTable: Get the Unique datatable and Dupliacte datatable Activities datatable , excel , uiautomation , studio	32	1105	February 12, 2024

Finding duplicate items in a datatable

Related topics