Skip to main content Skip to complementary content
Qlik Resources
Announcements
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

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 – please let us know!

Leave your feedback here