Hi Team, I have one data table, table contains 4 columns, First 3 columns any one column have unique values, so that scenario not a duplicate. Dt1 : input [IMG_20240223_123021] Dt2 : output [IMG_20240223_123054]

@AJITH_SK [image] Remove duplicate rows based on identical values in two columns Studio @n.k2020 Find starter help here: FindDupsUniquesFirstFromGroup_By2Cols.xaml (12.3 KB) check the reference

@AJITH_SK dt = dt.AsEnumerable() _ .GroupBy(Function(row) String.Join(",", row.ItemArray), Function(key) key.First()) _ .CopyToDataTable() I hope it helps

[image] AJITH_SK: I have one data table, table contains 4 columns, First 3 columns any one column have unique values, so that scenario not a duplicate. @AJITH_SK Can you try the below [image] DT.AsEnumerable() _ .GroupBy(Function(row) row.Field(Of String)("Name") & row.Field(Of Intege…

Data table how to remove duplicate rows

Help Studio

Krishna_Raj (Krishna Raj) February 23, 2024, 7:17am 3

@AJITH_SK

check the reference

Topic		Replies	Views
Get only unique rows from Datatable based on single Column Values Studio question	3	85	September 25, 2025
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	10	9816	November 28, 2019
DataTable Remove duplicate rows Studio studio , question , activities_panel	5	185	July 14, 2024
Remove duplicates from two columns Studio studio , question , activities_panel	10	945	April 10, 2023
How to Remove Duplicate Rows from the Data Table based on specific Column Name using Method Syntax Vote on Tutorials studio , faq	0	622	January 27, 2023

Data table how to remove duplicate rows

Related topics