Ignore row value/ move up column

[1adam_haj]

i have a table like this

Time 1	Time 2
01/01/2017 14:32:53	01/01/2017 17:32:53
01/01/2017 15:36:53	01/01/2017 18:32:53
01/01/2017 16:48:53	01/01/2017 19:32:53

i need to ignore or eliminite the first value in Time 2 ( red ) ant get the following value in the row instead of the first one. So the whole Time 2 should move up about one row.

how can i do that ?

[jonathandienst · Accepted solution]

If this is a front end expression, use Below()

[techvarun]

LOAD * INLINE [
    Time1, Time2
    01/01/2017 14:32:53, 01/01/2017 17:32:53
    01/01/2017 15:36:53, 01/01/2017 18:32:53
    01/01/2017 16:48:53, 01/01/2017 19:32:53
];


Data1:
Load Time1,Time2,Previous(Time2) as Time3 
Resident Data Order by Time1 Desc;


DROP TABLE


Data;

Try above script

[1adam_haj]

Thnaks, at the i added an ID with RecNo() +1 , but still thnaks Bellow made it too