Why I always get the last row data when using "For Each" with web scaping?

Help Activities
, ,
1

Hi, I’m trying to use “For Each” row in excel to do web scraping by "Get Text. The “Get Text” work normally but I only get the last row of the data in excel.
For example, I try to get temperature of each day in June 2022, so I list all the date in June in excel file and use “For Each” row in excel to scrape them from web. The result will always end up a data of 30th June every day. If I change the last row in excel file to 29th June it will end up a data of 29th June every day. The loop open web for each day as intend but not the data.

Thank you in advance.

2

@Cheatken can you put here excel screenshot for more clearance what you want and what is coming

3

Hi, The excel is like this
image
The data that I want to extract release twice a month.
I use those number to place in web URL so that it change each time according to the data release.

4

@Cheatken
Please check in datatable data is completely coming or not?.
For this use “output datatable activity” where give datatable and string veriable as output.

In message box put string output veriable.
Check data is coming or not.

5

Like this ?

image
image1287×356 15.5 KB

6

Yes. Now print string varible and check output

7

Yes It shows.
image

8

@Cheatken now show me loop and how you are getting data from it.

9

image

I use list of date to put in URL

10

@Cheatken so you are appending date in url?

11

I don’t really know what that mean, but I guess it is what you think.

12

@Cheatken can you give me workflow.

13

It is pretty long. Please tell me how can I do that?
Is there a way to extract and save the workflow?

14

@Cheatken please send over email.
raja.arslankhan@systemsltd.com

15

Ok, it should reach you in a few moment. Thanks

16

Ok give me few moments after lunch I wil look it. Hope for best.

17

Sure, thank you.

18

@Cheatken you are using Row(0) that way you get Last row value
you should be rowindex property of for each activity value instead of “0”

Thanks

1 Like
19

@sandeep13
Can you please tell me, how to do the rowindex?
Thanks

20

@Cheatken in the property panel you can see rowindex property use that variable

1 Like