I want to remove duplicate rows from a datatable if a particular column1 value is duplicate in other rows. dtOutput=dtOutput.DefaultView.ToTable(True,“column1”) when I try this it removes all the columns as well, but I need the rest of the columns.

You can try filter data activity if feasible

Thanks this works in getting the datatable sorted, but when I write the data table on the same excel sheet the remaining rows stays back… if I write on a different sheet it is fine. Can you tell me how can I write on the same sheet from where I am picking it up.

You need to first clear the Excel sheet. As read range will just overwrite the already present rows. Use hot keys to clear the excel sheet first then use a write range. Below are the steps Use Excel Application scope Select Range ->Menstion the sheet name and Range->“A1” use Send hot key → ctrl+…

@indra using your code I get the following error Assign : Unable to cast object of type ‘System.Double’ to type ‘System.String’. Can you help

@banerjeerules Do you change code in assign activity ?

I changed the whole excel to text format now it works

Remove duplicate rows based on a value from a single data column

Help

indra (Indra) June 19, 2018, 5:58am 2

@banerjeerules check attached file i hope its useful

RemoveDuplicatesInSingleColumn.zip (12.8 KB)

Remove rows or duplicates from datatable

Delete duplicate row based on one column duplicate data

How to remove duplicates from Datatable and count how many times it appears

How to get duplicate rows from column A and associated with those rows get not-duplicate values from column B

Topic		Replies	Views
Duplicate rows adding in the output file Help datatable , activities , question	29	2137	January 22, 2020
Remove duplicates from excel file Help	9	5355	June 3, 2022
How to remove duplicates entries from Row and it should remove that entire Column Help datatable , activities , question	20	3123	November 27, 2019
REmove duplicates from datatable excel Help datatable , activities , question	13	2793	November 14, 2019
Remove duplicates in excel along with row Help	6	3609	October 25, 2021

Remove duplicate rows based on a value from a single data column

Related topics