Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Yhank you ! it work with numbers, but dont work with dates... do you know why ?! thanks
No problem.
Do you have the example?, what are you trying to do with the dates?
the same think! but when i put dates in the field, the dates dont show... probably is an formating issue...
Try formatting your dates as numbers in your script num(DateField)