Remove duplicate cells in csv/data table

Hi, Need to remove duplicate cells in Particular column if cells are duplicate remove that entire row.
Ex: col1 col2 col3
abc def hij
klm def nop
qrst uvw xyz
1 uvw 2

out put: col1 clo2 clo3
abc def hij
qrst uvw xyz

@ram_charan1 - you can use remove duplicate row activity inside datatable category.

I used remove duplicate rows but i have only duplicate cells and entire row is not duplicate.


  1. Use Read Range activity to read data from excel file and will give you output as DataTable and say it ‘DT’.

  2. Assign newDT = DT.defaultView.ToTable(true,“col1”,“col2”,“col3”).copyToDataTable

Above one will delete duplicate records from original input data.

Thank you.

1 Like


If the above solution is working for you then close this thread by marking it as solution. It helps others too.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.