Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content
Qlik Resources

AutoNumber

This statement creates a unique integer value for each distinct evaluated value in a field encountered during the script execution.

You can also use the autonumber - script function function inside a LOAD statement, but this has some limitations when you want to use an optimized load. You can create an optimized load by loading the data from a QVD file first, and then using the AutoNumber statement to convert values to symbol keys.

Syntax:  

AutoNumber *fieldlist [Using namespace] ]

Arguments:  

Arguments
Argument Description
*fieldlist

A comma-separated list of the fields where the values should be replaced by a unique integer value.

You can use wildcard characters ? and * in the field names to include all fields with matching names. You can also use * to include all fields. You need to quote field names when wildcards are used.
namespace

Using namespace is optional. You can use this option if you want to create a namespace, where identical values in different fields share the same key.

If you do not use this option, all fields will have a separate key index.

Limitations:  

When you have several LOAD statements in the script, you need to place the AutoNumber statement after the final LOAD statement.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here