How to ignore if already scrapped

Help Studio
, ,
1

Hi ,

I have 1000 list of links in excel and i scrapped 100 out of it … next time if i run it needs to scrap from 101 and not from 1 … any help on this …

2

Hi @mssatheesh87

Have you use read range for getting data from excel…

Thanks

3

yes i have used under excel application scope …

4

@mssatheesh87

In read range give range as “”

Please use datatable manipulation package in this there was an activity called Select Custom N Rows

Use while loop and increase the counter by 100 and in the Select Custom N Rows activities property give starting row number and ending row number…

Thanks

5

Main
Main1270×2211 155 KB

see this image … i couldnt find select custom N rows

6

You have to install the package I provided…

Then in activities panel it will show

Thanks

7

Thanks … I have installed and it is reading from the starting row … should i place the select custom N rows under for each or after ream range …
and also i should not give each time starting row … for eg : some times it will scrap 80 data and some times 90 per day … so it needs to check automatically if data is there it should be scrap from next link …