topic Re: can anyone explain the difference between autonumber() and autogenerate() in QlikView

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

Fri, 17 Apr 2015 16:43:26 GMT

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

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

Anonymous — Fri, 17 Apr 2015 16:50:14 GMT

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.

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

Gysbert_Wassenaar — Fri, 17 Apr 2015 16:53:49 GMT

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()

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

maxgro — Fri, 17 Apr 2015 16:56:17 GMT

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.)