Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can anyone explain the difference between autonumber() and autogenerate()

can anyone explain the difference between auto-number() and auto-generate()

3 Replies
Anonymous
Not applicable
Author

The major difference is that the function autonumber() does exist, and there is no function autogenerate().

Autonumber() function creates a unique integer for each distinct value.

Autogenerate is used to generate a specified number of rows in the script, it is not a function.

Gysbert_Wassenaar
Partner - Champion III

Autogenerate is used to generate records for a table with a load statement.

Autonumber is used to generate a number value from a field value (or any expression in a load statement that returns a value). See this discussion: Re: AutoNumber() vs Auto..Hash()


talk is cheap, supply exceeds demand
maxgro
MVP

from QlikView help


autonumber(expression[ , AutoID])

Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.

Examples:

autonumber( Region&Year&Month )

autonumber( Region&Year&Month, 'Ctr1' )

autogenerate is used if data should be automatically generated by QlikView.

Load RecNo( ) as A, rand( ) as B autogenerate(10000);

(Note: The parenthesis after autogenerate is allowed but not required.)