Hi, How can i overcome with the following problem. I am having a datatable with 5 columns say A to E columns and N no of rows. Now, Column A has unique value. If B to E column has same set of row data i want to conisder it as single row. eg: if first 3 rows of data from the column B to E i…

You can use the following expression and get the unique values based on columns from B to E outputDataTable = InputDatatable.DefaultView.ToTable(False,“B”,"C","D","E") Regards, Karthik Byggari

No I just want to check the second row if not 3rd, if it matches we need to combine both the rows and consider as single row.

Distinct Rows from a data table

Help

Robott (Sajid Younas) March 6, 2020, 10:18am 4

DT1 = DT.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(1)).Select(Function(b) b.First).CopyToDataTable()

try thatDuplicate Row Data.zip (7.6 KB)

Get only unique rows from Datatable based on single Column Values

Topic		Replies	Views
Get only unique rows from Datatable based on single Column Values Studio question	3	72	September 25, 2025
Get datable based a input datable by multiple distinct columns Studio datatable , studio , question	1	642	June 2, 2021
Data table how to remove duplicate rows Studio	3	305	February 23, 2024
Merge two row contains same value in single wow in datatable Activities excel , uiautomation , activities	2	1115	April 5, 2021
Get distinct rows from Datatable from Multiple columns Help studio	6	4921	March 13, 2019

Distinct Rows from a data table

Related topics