Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator 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

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

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