Delete duplicate rows from a single column and overwrite that excel file

Help Activities
, ,
1

Hey,

I’m working on a project where every 5 minutes this robot will run. It will filter through unread emails by subject line, then save the excel attachment to a folder. It will use that path to open the excel files from that folder. The file will have 5 columns: PO Number, Part Number, Serial Number, PO Line, and Morgan Part Number. I want to delete any duplicate rows from the Serial Number column and overwrite the file with the new filtered data. So far, I have been able to do everything up until delete duplicates. Could anyone tell me what activities to use or explain a workflow? (I am fairly new to UiPath)

Thank You

2

image
image314×672 36.6 KB

This is what I have so far.

3

@dev.patel

just use write datatable to excel activity to write the filtered data back to excel.

4

The problem I am getting with that is that it doesn’t delete the original data. It just adds the filtered data to the original data.

5

@dev.patel

have you tried this, If not can you try this once

image
image1920×1078 229 KB

I think no need to read the excel you can use remove duplicates activity

6

Seems to work, thank you!

1 Like
7

Hey, after I delete the duplicates I want to copy the data from the excel file and paste into a website. How would I do that?
Thank You

1 Like
8

Hi @dev.patel ,

If you are copying the data row wise then use for each activity.

Thanks

9

I am copying the whole sheet, excluding the headers in row 1.