1 dimensional array Cannot be Convert to Boolean Error

Hi,
Scenario:
In web Data table scrapping column 9(Allocated FC)=0.00
then do some action(Action1) if greter than 0.00 then do some action(Action2),.

When i check the If condition getting error?
Any idea how to solve this?

1 Like

datatable.select returns an array of datarows. your condition is not correct.

1 Like

Can u text ? what r the conditions may possible here?

1 Like

what are you trying to achieve?

1 Like

pls see this,…

1 Like

from what i understood, you’re trying to do something if column-9 is bigger than 0, right?

you could iterate through the datatable using a for each row, then use an if activity with the following condition : cdbl(row(“Column-9”).toString)>0

also, ExtractDataTable.Select("[Column-9]=‘0.00’ OR [Column-9]<>‘0.00’) is redundant (it will select all the rows from the table because every row has column 9 either equal to 0 or not equal to 0)

1 Like

yes,. Exactly

all rows from the table then every row has column 9 either equal to 0 or not equal to 0.

If equal to 0 then do some action (print in excel) - this one success
If not equal to 0 then do some action(click) - this one i struggle?

1 Like

okay, so you have the datatable ExtractedDataTable right?

now, use a “FOR EACH ROW” activity on ExtractedDataTable.
Inside that, place an “IF” activity with the following condition: cdbl(row(“Column-9”).toString)>0.

1 Like

Thank you,. i m trying your comments,.Getting below error,.
I try include for each row

If: Column ‘Column-9’ does not belong to table
pls check attached screen shot,.

Hi @AnithaUi

First use the “Extract Structured Data” activity. You get the result in the form of a DataTable. Then your use the “For each row” activity. And inside this, use “Get Row item” and specify the name or index of the column for which your trying to check the condition. Take the “Get Row item” output variable and check it in your if condition.

Attached is the sample for your referenceDataTableUsageSample.zip (330.2 KB)

2 Likes

sudharani
Sorry late replying,… Thank you so much !! will let you know,.!

Thank you,. Now works fine :heart_eyes:

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