Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to give a field as KEY in next table:
I tried autonumber but I cannot give it.
Thank you very much
hello @lomi89 , please take a look at the documentation around this.
also autonumber will autonumber all fields with the function.
so if you say something like this (see codeblock) then it should autonumber.
Table:
load *,
autonumber(PRODUCT & YEAR & FECHA_COMP) as KEY
;
LOAD
PRODUCT, YEAR,FECHA_COMP
FROM (LOCATION) ;
hello @lomi89 , please take a look at the documentation around this.
also autonumber will autonumber all fields with the function.
so if you say something like this (see codeblock) then it should autonumber.
Table:
load *,
autonumber(PRODUCT & YEAR & FECHA_COMP) as KEY
;
LOAD
PRODUCT, YEAR,FECHA_COMP
FROM (LOCATION) ;
G'day @lomi89,
Would the rowno() or recno() functions give you what you want?
Cheers, Barnaby.