Hi, I want to delete rows that have the same data in a certain column. So for example I have 5 columns in my data table and a lot of rows. There are duplicates in ‘column 3’. I want to delete the entire row if there are duplicate codes in ‘column 3’ even though column 1,2,4 ,5 etc may not be dupli…

RemoveDuplicateRows.xaml (5.3 KB) The above attached workflow will remove the repeated mobile number rows. Thanks

@Ankit1 [image] Remove duplicate rows based on a value from a single data column Help @banerjeerules check attached file i hope its useful RemoveDuplicatesInSingleColumn.zip (12.8 KB)

Dear Sandeep, I tried it and ran the code. It ran fine but when I checked the output , the rows have not been deleted. Also I guess the column which I am using is Mobile no, so integer type, but when I tried to change datatype to Integer or double, it gives error as “specified cast is not valid” …

Also have attached the input data, based on column name Moile No., we have to delete duplicate row. Please see if you can help. data.xlsx (11.9 KB)

Thanks Praneet, but i was expecting output in data table form

just use this expression dt = arrDataRow.CopyToDataTable

No praneeth, even after using arrDataRow and using same code as you attached, the duplicates rows are not getting deleted. The process run fine but row do not get deleted :slightly_frowning_face:

Actually, it was my fault praneet. Sorry. Its working fine now Thanks a lot… :blush:

Delete duplicate row based on one column duplicate data

Help Studio

sandeep13 (Sandeep Pathak) April 28, 2020, 7:18am 2

@Ankit1

Topic		Replies	Views
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	11	9702	December 1, 2019
Excel/Datatable Remove ALL Row with duplicate colums Help datatable , excel , activities	17	1734	May 16, 2020
How to delete duplicate rows on the basis of single column from a datatable Studio studio , question , activities_panel	1	980	June 27, 2021
How to remove duplicates entries from Row and it should remove that entire Column Help datatable , activities , question	20	3099	November 27, 2019
Need To Remove the Row on the basis of Duplicate value in Column Activities activities , question , script	8	901	July 31, 2022

Delete duplicate row based on one column duplicate data

Related topics