Need to obtain the next value of a field in another column

[Anonymous]

I have a table with the values:

Field1

10

5

2

8

I need to create another field which gives me the next value of the Field 1.

i.e

Field1      Field2

10               5

5                 2

2                 8

8                 -

Please provide a solution..

[sunny_talwar · Accepted solution]

Try this

Table:

LOAD *,

RowNo() as RowNum;

LOAD * INLINE [

    Field1

    10

    5

    2

    8

];

FinalTable:

LOAD *,

Peek('Field1') as Field2

Resident Table

Order By RowNum desc;

DROP Table Table;

[buzzy996]

check this

[Anonymous]

Thanks mate.