Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
m_perreault
Contributor III

Autonumber Question

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Autonumber Question

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

1 Reply
Partner
Partner

Re: Autonumber Question

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