topic Autonumber Question in App Development

Autonumber Question

m_perreault — Tue, 23 Oct 2018 13:00:37 GMT

Hi All,

I have a QVF in which a number of key fields are Autonumbered. In a new App if I use a Binary Load to load all data from this QVF then add some new data with an Autonumbered key field will this work or will the counter of the Autonumber be reset.

Ex. QVF1 has an autonumbered field %Key

QVF 2 Script:

Binary [lib://QVF\xxxxxxxx];

NewData:
Load *,

Autonumber(KeyField,'KeyField') as %Key

From xx;

Thanks,
Mark

Re: Autonumber Question

dplr-rn — Tue, 23 Oct 2018 14:07:20 GMT

Couple of things. you need to be careful with binary load on Sense. see below

Qlik Sense substitute for BINARY load

Auto number works per load. suggest using hash functions instead of autonumber.

snippet from help page below

You can only connect autonumber keys that have been generated in the same data load, as the integer is generated according to the order the table is read. If you need to use keys that are persistent between data loads, independent of source data sorting, you should use the hash128, hash160 or hash256 functions.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterFunctions/autonumber.h…