Hello, I wanted to remove all duplicates including the original row based on column “Material” from the data table Example : Input [image] Output [image] The output should not contain the duplicates. Thank You,

@Yugal_Raju Try this linq dtInput.AsEnumerable().GroupBy(Function(row)row(“Material”).ToString).Where(Function(g) g.Count() = 1).SelectMany(Function(g) g).CopyToDataTable()

Remove all duplicates rows based on a column

Help Studio

lakshmi.mp (Lakshmi Mp) November 14, 2024, 7:17am 2

Hi @Yugal_Raju ,
Refer this link, hope this helps

Topic		Replies	Views
Remove Duplicate Rows based on Column Activities excel , activities , question	6	9193	March 14, 2024
Remove duplicate rows based on conditions Studio question	13	2537	February 8, 2021
Remove Duplicate rows based on single column and that too if cell starts with specific values Activities excel , activities , question	22	900	October 12, 2023
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	11	9523	December 1, 2019
How to Remove Duplicate Row If the Value from two Columns matched Activities excel	5	3587	March 13, 2022

Remove all duplicates rows based on a column

Related topics