Data Scrap-1 lakh rows

Help
, ,
1

Hi
I need to scrap the data, but no next page option but only scroll option.
It is scrapping upto 31 rows but has around 1 lakh rows.

I can’t use find children because with this data I need compare with other data table.

2

Hi @KarthikBallary

Have you set Max Number of results property to 0 in Data Scrapping Wizard

Thanks
Ashwin S

3

yes!!!

4

Hi @KarthikBallary

Share your xaml

Thanks
Ashwin S

5

sorry confidential matter

6

Hi @KarthikBallary,

You can try with this approach:

  1. Use Image exists activity and check for which specifies its end of page.

  2. Now loop until its false.

  3. Inside loop use send Hot key page down.

  4. once you reach end of page then scrap the data, you will get full data.

Let me know for any issues…

7

There is no page number or something. that table is dynamic. how do I know page is ended?

8

When there is no more to scroll down the send hotkey will produce an exception after timeout. Catch that exception to know the page is ended.

1 Like
9

Ok,
I can export that table to excel. I can filter that table based on column. suppose if a column contains points>2000. and scrap the data.
Can filter excel table if so how?