ayahya82
ayahya82

Reputation: 386

How to convert @OFFSET function from SPSS to HANA?

I have to implement some logic from SPSS to HANA. It was ok until I found this function on SPSS: @OFFSET. What is the similar way to implement this function on HANA? I found on SPSS something like:

@OFFSET (<Column1>, 1) = column1 and @OFFSET(<Column2>, 1) = Column2

enter image description here

Upvotes: 0

Views: 372

Answers (1)

ayahya82
ayahya82

Reputation: 386

Problem solved using window function LAG()

Upvotes: 1

Related Questions