How do I use if activity to loop through the rows and check a column condition?

Help Activities
, ,
1

For example if status = “valid” , proceed to execute a set of activities else move to next row if status is not valid.

2

On the Else side of condition Status = “Valid” use Continue Activity which would skip the current transaction

3

Hi @Vivian_Thian

In the For Each Row in Data Table activity, add an If condition & check:

currentRow(“Status”).ToString.ToLower.Equals(“valid)

In the True block of the If condition, keep the set if actions that you want to perform.

In the Else block, just keep the Continue activity, so the the next row will be picked up.

Hope this helps,
Best Regards.

4

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