How to assign previous value to stage variable?

[taral]

I want to remove duplicate using stage variable.
For doing this I need to compare the current value of column with the previous value.
How do I maintain previous value in the stage variable?

[kondeti]

Use this logic.

SCurrent: Link.input_key
SCompare: If SCurrent=SPrev then SCompare+1 else 1
SPrev:SCurrent (Default it to some empty value like "")

Thank you.

[kondeti]

Sorry missed most important thing.

Before applying the above logic, Please sort the data on the key column then apply above logic. Thank you.

[taral]

Thank You kondeti.

Do you mean
SCurrent value needs to be assigned to SPrev.

[chulett]

Yes. What is key to this is the order you declare the variables as they are evaluated top to bottom. That is what allows you to still know the "previous" value when the "current" value shows up.