Remove duplicate cells in csv/data table

Help
1

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

2

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

3

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

4

@ram_charan1

  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.

6

Thank you.

1 Like
7

@ram_charan1

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

8

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