key field autonumber function

[lomi89]

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

[MartW · Accepted solution]

hello @lomi89 , please take a look at the documentation around this.

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterFunct... 

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) ;

[barnabyd]

G'day @lomi89,

Would the rowno() or recno() functions give you what you want?

Cheers, Barnaby.