URGENT ! What if I want the robot to run a loop by reading a process column that doesn't have a value yet?

Help Studio
, ,
1

I have a project

First, I use the use excel activity to open Excel.

In Excel there is a “Process” column stating that if the data has been processed it will have a value of “Yes”, a value of “No” and no value yet.

What if I want the robot to run a loop by reading a process column that doesn’t have a value yet?

There is no need for the robot to repeat itself, always starting with the first data.

Am I right if it’s like this?

image
image820×556 16.1 KB

2

Hi @Kia1 ,

Place an if condition inside the for loop.
Replace the ‘excel’ in Item Field with ‘Row’

Condition :
Row(“Process”).Tostring = “No” or String.isnullorempty(Row(“Process”).Tostring)

In then part, place the steps for the process.

This would ensure if the cell is empty or has No. Steps for processs will be done.

Thanks,
Gautham.