Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is probably a simple question due to being a beginner....but I want to identify a field that is more rows up than just previous in the load script. I prefer this to be named to a new field in the load script due to sorting issues, but open to ideas within a straight table as well.
I have ordered my table by a "Date" field and I want to identify the Date that exists 9 rows up in the table and call it "Prev_Date".
I tried the previous function, but then realized that I have multiple of the same date. So I will need to make the Date field distinct and then look 9 dates up. Any ideas?
Sarah,
Could you provide some sample data, with expected outcome?
Thanks
Oscar
Peek(Date,-9) as Prev_Date