Autonumber Question

[m_perreault]

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

[dplr-rn · Accepted solution]

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/CounterFu...