Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 amarnadh naidu kapa (Amar_nadh)
Accenture
RPA developer
Accenture
IN
Amar_nadh Member since 2016 8 posts
Accenture
Posted: Dec 1, 2017
Last activity: Dec 1, 2017
Posted: 1 Dec 2017 1:07 EST
Last activity: 1 Dec 2017 7:12 EST
Closed
Solved

Finding Duplicate rows in Excel and Updating Status column as Duplicate

I have a scenario to find the duplicate values , and update the status cloumn as Duplicate

I have Excel with 20 columns , Acc No , To date , From Date columns are there if incase theese three values maches with any row of the three values then i need to update the Status column as Duplicate .

I am able to get those three values and compared it successfully but unable to set the Status column .

Can anybody help on this.

i have attached my automation below.

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Robotic Process Automation

Accepted Solution

Posted: 6 years ago
Posted: 1 Dec 2017 6:16 EST
amarnadh naidu kapa (Amar_nadh)
Accenture
RPA developer
Accenture
IN

Hi

I have attached my automation pics above ,

and to set the corresponding Status column value as Duplicate i have done this (Please find the below attachment).

Thank you

To see attachments, please log in.

Accepted Solution

Posted: 6 years ago
Posted: 1 Dec 2017 6:16 EST
amarnadh naidu kapa (Amar_nadh)
Accenture
RPA developer
Accenture
IN

Hi

I have attached my automation pics above ,

and to set the corresponding Status column value as Duplicate i have done this (Please find the below attachment).

Thank you

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice