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
How to check if there are duplicates in the rows of Data Table Academy Feedback	10	13879	October 29, 2018
Only keep duplicates in Data Table Help datatable , activities , question	4	2626	May 13, 2020
How to get duplicate rows for specific column in a datatable Help datatable	4	10432	October 29, 2018
I want to remove duplicate rows from datatable by comparing single column Studio datatable , activities , question , data_manipulation	14	5327	March 6, 2020
Check For Duplicate Row On DT And Mark All The Duplicate With "Duplicate Data" Something Else feedback	7	1218	November 25, 2022

Duplicate rows in data table

Related topics