Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the use of Auto Number?Autonumber128? What is the disadvantages of using Autonumber128?

Hi All,

What is the use of Auto Number?Autonumber128? What is the disadvantages of using Autonumber128?

Thanks,

Attitude

1 Reply
Not applicable
Author

I don't know full diferences, but one very important is:

Autonumber has a second parameter, called AutoID to create separate list of value for each concept.

For example I have 10Millions of Document ID, then 10 Million of Customer ID also in the autonumber list, and then 200 Product ID.

It's a best practice to separate products on a diferent list of values, because find/insert value product 199 in a list of 198 products is better than finding in a list of 20.000.198 records.