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…

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

1 Like

Topic		Replies	Views
Check For Duplicate Row On DT And Mark All The Duplicate With "Duplicate Data" Something Else feedback	7	1190	November 25, 2022
Finding duplicate items in a datatable Studio datatable , uiautomation , activities , question	10	12318	March 20, 2020
Same data-table compare Help activities	5	1223	February 17, 2020
Get unique values by multiple columns in datatable Help studio , question	4	2880	December 15, 2020
Working with Duplicates DataTables Help	4	1130	March 4, 2019

Duplicate rows in data table

Related topics