How to keep extracting data from a data table in a loop until no more data?

Help Activities
, , , , ,
1

I want to create a condition that will keep that means in a Loop extracting data from a table until there are no longer data to extract . The bot will use get visible text and will stop if there are no longer data to extract on the table.

So what happens is that bot will use get visible text and if there are result on extraction the bot will submit those data will be gone on the list and new list would comeup and then bot will extract again until no more to extract.

If you ask why the reason is the app has a submit button so my idea is bot will extract the first list and submit and while there are still remaining data then the bot will continue and repeat the extraction. Any idea ? thanks . would a while loop a good idea ?

image
image725×457 16 KB

2

Hi Sir @NIVED_NAMBIAR . do you have idea on this one Sir ? Thanks

3

Hi @AhmedKutraphali

You can try this way

Since you are filtering by date

so first filter for day let say u want to filter data between 15/02/2020 to 22/02/2020

So first filter from 15/02/2020 to 15/02/2020 and you can see that data. Scrap the data and append to the excel

Next filter for another day that filter from 16/02/2020 to 16/02/2020 and you can see the data and scarp it and append to excel

That way you can do for date upto 22/02/2020

I know it is a bit slower approach, but since screenscrapping, data scarpping and other methods i had suggested is not working, you can try this

Regards
Nived N
Happy Automation

4

Never mind the dates Sir . I just want to know how to dynamically loop datable extraction using get visible text. Do you have some example ? any tables would do I just want to see how to implement

Its like while datatable has data or result not empty keep on extracting using get visible text.