How to delete duplicate email addresses

[pabaleloh]

Please assist i am using web application So, after clicking email

This is what shows up, thus I want the bot to remove one row after checking for duplicates under the Name column.

[Anil_G (Anil Gorthi)]

@pabaleloh

you can extract the rows to datatable using extract table data

then find only the duplicate rows and then delete only them using the url you get for delete or the unique identifier or the row number

for identifying duplicates you can use linq

cheers

[Anil_G (Anil Gorthi)]

@pabaleloh

may I know what you have tried out of the steps I told there..do you face any challenge?

cheers

[BotCurator]

You can achieve this by extracting the table into a DataTable, checking for duplicates in the Name column, and then deleting only one of the duplicate rows from the web page.

Here is the recommended approach:

1. Use:
   • Table Extraction (Modern Browser)
   or
   • Data Scraping (Classic)

This will give you a DataTable, let’s call it dtTable.

2. Identify duplicate names

Use this LINQ to find duplicates:
duplicateNames = dtTable.AsEnumerable().
GroupBy(Function(x) x(“Name”).ToString.Trim).
Where(Function(g) g.Count > 1).
Select(Function(g) g.Key).
ToList()