Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
If this is a front end expression, use Below()
If this is a front end expression, use Below()
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
Thnaks, at the i added an ID with RecNo() +1 , but still thnaks Bellow made it too