Hi all! I have a data table with 23 columns and I need to find duplicate rows. For each duplicate row I need to add a flag on both identical rows on a 24th column. Whats the best approach? I have been searching the forum but I only find examples comparing one or two columns. I need to check all 23 …

@cristian_ivanoff Add DataColumn byusing Add DataColumn activity to dt name it Flag Extract the Duplicate rows and store in a datatable dt1 Get the distinct values by using dt2=dt1.DefaultView.ToTable(True) Run for each row for datatable dt in if condition (From p in dt2.Select() where strin…

@cristian_ivanoff refer this post [image] How to get duplicate rows? Help @SHAISTA You have to replace dt with your datatable Variable and assign the result to one more datatable variable** (From p in dt.Select() where( From q in dt.Select() where string.Join(“,”,q.It…

Great! Thanks @arivu96 @MAHESH1 (From p in dt.Select() where( From q in dt.Select() where string.Join(“,”,q.ItemArray).Equals(string.Join(“,”,p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() This returns a data table with all the duplicate rows. Any ideas how to just a…

OMG! This is working perfect! Thanks guys…Data tables are not so fun to work with :smiley: Br Cris

Hi @cristian_ivanoff , You can use “Remove duplicate rows” Activity also to remove the duplicates. Below I have attached a sample . File : DatatableSample.zip (2.1 KB) [image] Regards Balamurugan

hi, please follow below tutorial to remove the duplicate rows in the data table. [UiPath Tutorials For Beginners - DataTables Part-2] thanks, Karthik.

Hi Guys, If the duplicate names exist in column, how to select the first row of the duplicate column. Thanks & Regards, Jeevitha

@JeevithaBA Do the Group by for the Datatable based on column which is having duplicate values and take the first value of that group. Let us take the datatable as dta as your original datatable dtb = (From p In dta.Select group p by ID=p("Column_ Name").ToString To Group Se…

Hi Mahesh, Thank you for your response, I have tried to add that but iam getting error

@JeevithaBA try below code. It might be useful. DataTableName.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(“column_name”)).Select(Function(b) b.First).CopyToDataTable()

Duplicate rows in data table

Help

arivu96 (Arivazhagan A) March 5, 2018, 5:43pm 3

Hi @cristian_ivanoff,

Refer this post,

DataTable filtering with expressions

Regards,
Arivu

Topic		Replies	Views
Check For Duplicate Row On DT And Mark All The Duplicate With "Duplicate Data" Something Else feedback	6	1295	November 25, 2022
How to check if there are duplicates in the rows of Data Table Academy Feedback	9	13982	October 12, 2018
Only keep duplicates in Data Table Help datatable , activities , question	4	2755	May 13, 2020
Data table how to remove duplicate rows Studio	3	332	February 23, 2024
I want to remove duplicate rows from datatable by comparing single column Studio datatable , activities , question , data_manipulation	13	5453	March 3, 2020

Duplicate rows in data table

Related topics