Reading Data Table from website and comparing with an excel doc

Help Studio
, ,
21

image
this is what I currently have as the value to save for the variable “Value” that is saved as an object currently

22

image
image1271×740 42.7 KB

24

I am still getting an issue where CurrentRow1 and CurrentRow2 say they have not been declared - I’m not sure why this is as they are established as Outputs on each For Each Row in Data Table activity

1 Like
25

@R_Wolff

Have you changed the CurrentRow in first for each row in data table to CurrentRow1? and CurrentRow in second for each row in data table to CurrentRow2?

Regards

26

Yes I have - my current issue is that when I go to assign “value” as CurrentRow2(“Value”) I am getting the following error
image

27

@R_Wolff

can you send me the screen shot of the assign activity ?

regards

28

Hi @R_Wolff

Please remove double quotes and reassign double quotes

1 Like
29

image

30

@R_Wolff

CurrentRow2("Value").ToString

please remove the double quotes and place them again

Regards

31

Awesome that is now working - my only issue now is it is not looping through all rows from the Excel data table - it just keeps trying to input the first number found in the list

32

@R_Wolff

Can you share the flow please

Regards

1 Like
33

image
image614×582 20.8 KB

image
image502×549 15.8 KB

34

@R_Wolff

what is the syntax in if condition?

regards

35

image

36

@R_Wolff

Use the below syntax in the if condition

CurrentRow1("Account Header").ToString.Trim.Equals(CurrentRow2("Account Header").ToString.Trim

Regards

1 Like
37

image
image1287×619 31 KB

that yields this error code

38

@R_Wolff

sorry for the late reply please keep the closing bracket at the end.

CurrentRow1("Account Header").ToString.Trim.Equals(CurrentRow2("Account Header").ToString.Trim)

hope it helps!!

39

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.