Skip to main content

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.