Extracting Value of Row +1 in a For Each Row Logic

Help
1

There is a case when robot need to loop each row through and repeat different sets of action in a third party system.

There are different action to be performed based on the column data in row, row +1, row +2…

For each row, I have to check if Column A contains value, if yes, I would need to check if Column A in row +1 is empty AND Column C in Row +1 contain value to decide what to be performed.

With the get row items function in a for each loop, I can extract value for the current row, but is there anyway i can extract value in row +1 , row +2… without affecting the logic of for each row.

image

1 Like
2

Use Read Cell activity to read only one cell value.

1 Like
3

Please find the attached flow.row_Increment.zip (16.7 KB)

1 Like