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

Help Activities
, ,
21

@sandeep13
Like this? What kind of Variable type I should be using?
Thanks

image
image1306×371 18.9 KB

22

@Cheatken
property of For each activity

image
image989×371 15.8 KB

you just to create variable interger type and use that variable in place of 0 like Row(index)

Thanks

1 Like
23

@Cheatken

FYI. Index property give us the current iteration index of for each loop

Thanks

1 Like
24

@sandeep13

image
image1305×497 31.6 KB

Like This ?
image

Thanks

1 Like
25

@Cheatken yes ,right

1 Like
26

@sandeep13
Ok, I change the name a little so that it help me recognize index as integer variable.
Though it shows error “Cannot find column 1”

image
image1040×177 12.4 KB

Thanks

27

@Cheatken
to access value form row object , use code like this
Row(int_indexRow)(“yourColumnname”)

I think in you case Row(int_indexRow)(“Date”)

28

@sandeep13
Seems like the syntax I use is not match somehow.
image
image

29

@Cheatken
could you please just check the value of Row(int_indexRow)(“Date”)

1 Like
30

@Cheatken

I found it, you just need to use column name like
Row(“yourColumnname”)

As I saw earlier you was using For each Activity and latest post I saw you are using For each row Activity
In the For each row activity we don’t need index Property because For each row itself current iteration index

Thanks

31

Ok, let me try
Thanks

32

@Cheatken was you check my email. I was unable to open your code. Can you simple send me Zip file.

33

@raja.arslankhan
Unfortunately I do not have Winzip.
Is it possible to send just the “main” instead?
Thanks

34

@Cheatken yeah sure please send me. Maybe it will be helpful

35

@raja.arslankhan
Ok I send another zip and main to you.
Thanks

36

@Cheatken Yeah, I received. Hope for best

37

I got it!
I need to use “Add Data Row” activity each time it get text from web. The data column need to be added in advance when create data table, not later on.
Thank you guys very much :slight_smile:

38

@Cheatken sorry, I have develop your code but forgot to upload. I will upload evening your optimize solution. Its best you have solved a problem with your own way. Happy learning

39

Main.xaml (166.3 KB)

Hi @Cheatken
I noticed your code is holding best practices, For Example you are building data table in loop.
Always build datatable outside loop.

Then you are adding number of columns in loop which will add every time. It should be in build table.

Last one you are not adding add row that’s why you are getting only last iteration value. This point you know already.

I am add here template of code. Not exact code due to your studio language.

40

ok Thank you :slight_smile: