Hi guys,
is there a way that i can compare the current row to the previous row?
The logic is this:
If CurrentRec = PrevRec
Then
ColumnOut= PrevRec
Else
Current Row
Thanks,
Keith
Compare the current row to previous row
Moderators: chulett, rschirm, roy
Short answer is yes.
This article might help with the whole record approach. You should also become very familiar with stage variables as they can be used to hold previous values (including a complete record string) since they are evaluated in order from top to bottom.
This article might help with the whole record approach. You should also become very familiar with stage variables as they can be used to hold previous values (including a complete record string) since they are evaluated in order from top to bottom.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers