Hey guys, i’ve seen similar questions here before but can’t really translate the answers into what i need so i’ll see if someone knows how to solve this.
I need to be able to while in an for each row activity, check the next(upcoming)row for a certain value using “.contains” and if there is a match, perform an action. I know i need to use something like “rowindex+1” in an IF activity. But cant get it to work. Right now im at something like this:
But row(currentindex+1).tostring.Contains (“PATEAM”) give me an error saying that column 1 cant be found. So it’s not looking at the next row but the next column.
What would the correct statement be for it to check the next row, not the next column?