Data extraction only first 25 rows dos not ectract all the rows in web table

[RPA_Dev13]

Hi Guys,
I have a problem with the extraction of data, the robot extracts only the first 25 rows and the table changes every day to 20 rows and another day to 100 rows, Does anyone face this problem and have a solution?

[Anil_G (Anil Gorthi)]

@RPA_Dev13

The issue might be with webpage

have wait for load to complete …also check if the table data is loading dynamically then you might need to scroll first till end and then extract

Not: this will work only if the table loads all data, for few websites the table loads dynamic and the old loaded rows will be over written with new as you scroll…if that is the case then you might need to follow a logic to scroll extract and repeat

Hope this helps

cheers

[Rooty (Mohamed El Ouehabi)]

Hello @RPA_Dev13

Make sure you have selected “No limit” for the limit extraction option :

Cheers

[RPA_Dev13]

I did all of that but same problem extract only first 25 rows

[Rooty (Mohamed El Ouehabi)]

Hello again,

I did a quick search on the forum, and have found two solutions for two different problems you could have :

Table Extraction only extract 10 rows

@loi.nguyen You need to indicate another item within the range of next 10 rows(beacuse it’s tend to capture 10 fields only) then check if all the fields is selected or not. If not selected then indicate the next item in the following 10 rows. If after indicating the next item in the following 10 rows tends to clearing the first 10 rows selection then try indicate any item in that first 10 rows again except first and last fields. Regards, @supriya117

Data Scrapping issue - Scraps only one row at a time, be it first, second, or third etc

Hi Team, @HareeshMR, @Palaniyappan, @Antoine_Chaussin, @loginerror, @lakshman I am using Data scrapping for a website and when I am clicking on the element for data extraction, I am directly getting a box asking if I want to extract the entire table. Even if i select yes, it only extracts first column and displays in the interface. I tried to write it in the excel sheet but still it shows only one row in excel Please help,.\ Thanks and Regards, @hacky

Take a look at these links, and let’s hope one one of them solves your issue.

Cordially,

[Anil_G (Anil Gorthi)]

@RPA_Dev13

Did you try the above approaches?

cheers

[RPA_Dev13]

Hi thanks, guys for the help, all suggestions do not help to solve this problem.
but instead of extracting the data table online, I got the option to choose to download the table as an Excel file, and that helped me to continue working on the process.