Compare the current row to previous row

KFajardo · Post by **KFajardo** » Sat May 23, 2015 11:49 am

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

chulett · Post by **chulett** » Sat May 23, 2015 3:17 pm

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.

KFajardo · Post by **KFajardo** » Sun May 24, 2015 10:13 am

Thank you,chulett for answering my questions with dedication. I really appreciate it.

And, yes. I really have to study more about stage variables. That's reason why I am asking a lot.

Thanks again. I will check the link.

keith