How to check a previous value in a variable in a for loop?

[ajeffers]

Hello,

I am looping through a datatable in the following manner:

I want to create variable that houses the previous value of PHYID, (basically the value before the current value it finds in the regular loop) to use as a comparison later.

How would I do this in code?

[muhammedyuzuak]

Hi @ajeffers,

Define an index inside the loop.Then you can assign as follows.

dtResult.rows(index-1)(“ColumnName”).ToString

Regards,
MY

[ajeffers]

What would I set the index as? 0?

[muhammedyuzuak]

It will start from default 0. You create that index in the for, it will increase as the loop continues. When you stop according to a condition, -1 of this index will bring you the previous row.

[ajeffers]

Code worked fine but then it threw an error

“Assign: There is no row at position -1.”

What would I do to bypass the initial header?

[muhammedyuzuak]

By adding a condition, you can say don’t do this assign operation in case index = 0.

[ajeffers]

@muhammedyuzuak

dtResult.rows(index-1)(“ColumnName”).ToString

Thank you! This seems to work