Data Scraping Duplicates

[Abdul_Khaliq1 (Abdul Khaliq)]

Hi!,

I am doing a Data scraping activity from a web page. when I write range to workbook, the results that i fetch have duplicates. For example I am data scraping 10 rows of information from a webpage, but the results show me 30 rows which means each row is duplicated 3 times. How do i solve this problem?

Thanks!

[Sudharsan_Ka]

HI @Abdul_Khaliq1

You can use Remove duplicate rows activity before writing them in to the excel sheet

Remove duplicate rows in Excel with UiPath Example

How to Remove Duplicate Rows from DataTable in UiPath?

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @Abdul_Khaliq1

Before using Data scrapping activity use Clear Data table activity. and After writing the data in the excel file use Clear Data table activity and check it.

Regards
Gokul

[fernando_zuluaga]

Hey

Give a try using the Remove Duplicate Rows Activity

Regards

[mohiniganesh15]

Hi @Abdul_Khaliq1 ,
Please go through below topic it may help you …

Duplicates with data scraping wizard

Trying to use the data scraping wizard to get videos from google using the video button and it seems to work fine with titles and URLs. But when I add the date or description fields, I get duplicates where there is no data in the “Date” field. [image]

Regards
Mohini
Happy automation…!!!