Order Table

[#1]

Hello everyone! i have an issue to create one table like that :

Field 1	Field 2
A	B
B	C
C	D
D

I want to create a table, like the forward example, in the Script Editor.

From field A, I want to create a field B equal to that shown in the figure. In field A I have the order "A - B - C - D" and I want to create a field B associated to field A with the Association "B - C - D" where A = B and B = C and C = D.

Help me please.

[eespiritu · Accepted solution]

Hi,

Try to use this code:

TMP_TABLE:

LOAD * INLINE [

    ID,FIELD1

    1, A

    2, B

    3, C

    4, D

];

NoConcatenate

Final:

Load

  ID,

  FIELD1,

  Peek('FIELD1') as FIELD2

Resident TMP_TABLE

order by ID desc;

Drop table TMP_TABLE;

Regards,

Enrique

[#3]

Yhank you ! it work with numbers, but dont work with dates... do you know why ?! thanks

[eespiritu]

No problem.

Do you have the example?, what are you trying to do with the dates?

[#5]

the same think! but when i put dates in the field, the dates dont show... probably is an formating issue...

[Anonymous]

Try formatting your dates as numbers in your script  num(DateField)