Удаление дубликатов и отправка письма

Sudharsan_Ka · October 6, 2022, 11:24am

Sudharsan_Ka:

You can also try this

If you want to remove the duplicate rows based on one column check with this expression
(From p in DT.Select() where( From q in DT.Select() where q(“NLC”).Equals(p(“NLC”)) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()
If you need to get only the rows with one occurence means check with this expression
DT.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(1)).Select(Function(b) b.First).CopyToDataTable()
You can also try with this
Datatable.DefaultView.Totable(true, {"list", "of", "column","names"})

Try with these @antonstep9213

Topic		Replies	Views
Remove All Duplicate Rows Activities excel , activities , question	5	1127	November 7, 2022
How to remove duplicate andalso delete this row Activities excel , activities , question	7	238	January 12, 2024
Want to remove duplicate rows from merged data table Help	6	1797	February 14, 2020
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
Remove Duplicate Rows based on Column Activities excel , activities , question	6	9191	March 14, 2024

Удаление дубликатов и отправка письма

Related topics