i am using studiox 2020.10.2 . I want to build a condition to check for each excel row if current row and next row value is the same. how can i do that and it will work inside the for each excel row module how it would react when its the last row and there is nothing as next row ?
i-i cant. i would like to but i cannot switch between studio and studiox, company did restrict it for some reason that i dont know. thats why i am stuck and especially wrote down that i am using studiox and its version
While loop condition Count<(DTInput.Rows.Count-1)
where count start with “0”. Variable type is int32
Count=0, Place it above the loop
Dtinput is read data fromexcel
If condition DTInput.Rows(Count)(“ColumnName”).ToString=DTInput.Rows(Count+1)(“ColumnName”).ToString
If current row equals to next row, else current row not equals to next row