To remove duplicates in excel

Help
1

I’m comparing two excel sheet and I want to remove the duplicates in excel2 when I was calling excel1

2

@Bachali

Follow below link

https://www.google.co.in/amp/s/www.uipath.com/kb-articles/excel-automation-delete-duplicate-rows%3Fhs_amp=true

3

Thank you so much but in my case I was comparing two Excel sheets.

4

can you give some sample data

5

name.xls (10.5 KB)

6

consider that this excel read and stored in dt

dt=dt.DefaultView.ToTable(True,“name”,“domain”)

this will return the Distinct values from the both column name and domain

1 Like
7

I got it thank you so much

8

Man you are awesome.
But can you plz tell me, where can i learn more about Uipath Studio, its methods, activities. I have already completed my training from UiPath academy.

1 Like
9

Hi,
Using this can remove the duplicate rows from excel.

Regards
Balamurugan.S

1 Like
10

Hi @balupad14,

Here to remove duplicates in some columns,I tried with remove duplicates
We don’t the range specific from starting B1,ending it depends on data
Can you suggest anything for this

11

Hey

Here is a detailed article on that :slight_smile:
# How To Remove Duplicates From Datatable In UiPath

Regards,