Search code examples
spsshana

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


Solution

  • Problem solved using window function LAG()