Reading Data Table from website and comparing with an excel doc

awesome that seems to work - going to test input back into the website now

1 Like

Show me once what you have given in the value to save field in assign activity. @R_Wolff

1 Like

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

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

@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

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

@R_Wolff

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

regards

Hi @R_Wolff

Please remove double quotes and reassign double quotes

1 Like

image

@R_Wolff

CurrentRow2("Value").ToString

please remove the double quotes and place them again

Regards

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

@R_Wolff

Can you share the flow please

Regards

1 Like


@R_Wolff

what is the syntax in if condition?

regards

image

@R_Wolff

Use the below syntax in the if condition

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

Regards

1 Like


that yields this error code

@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!!

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