If condition loop back and rescan from the next column in excel

[Srikanth_Goud (Srikanth)]

Hi,

I am trying to Read the date from “A2, B2” from an excel and use if condition for B2.

if the condition is true it performs THEN.

if the condition is false it goes to ELSE.

Now in Else Condition, I want the go back to the excel and read “A3,B3” .It should perform the loop until the condition satisfies.

screen shot below…

[LiDo (Liviu Dogaru)]

Hi @Srikanth_Goud,

Add a Do While Activity before the first If Activity and type the condition that must be satisfied in the Condition section. Then move the rest of the activities inside the Body section. To be easier you can even collapse the first If activity before move it.

[Srikanth_Goud (Srikanth)]

Hi @LiDo ,

Are you able to provide with an example… i cannot understand the logic!

[AndresTarazona]

Hi @Srikanth_Goud

Following your graphic, I did not see any new assign for your variables SITE and WO. Also I see an Break activity, I suppose that you are using a For Each activity, in that case you can add an if activity next to your nested if checking if your WO and SITE variables are empty.

Regards,
Andres

[Srikanth_Goud (Srikanth)]

Hi All,

I have tried a different method using If else activity for the “WO” i which i left the THEN part empty with no activity so that i can skip the process and proceed to scan the next “SITE”.

It worked out!

Thank you so much for you response.

Much Appreciated!

Thanks,
Srikanth.