topic AutoNumber() vs Autogenerate() in QlikView

AutoNumber() vs Autogenerate()

Fri, 13 Feb 2015 10:12:48 GMT

Hello,

Pelase explain me difference between AutoNumber() and AutoGenerate() and it's purpose.

Thanks,

Uday.

Re: AutoNumber() vs Autogenerate()

alexandros17 — Fri, 13 Feb 2015 10:15:29 GMT

Autonumber return a unique numerical representation af ne or more fields and can be used to compose fields to create a unique key,

Autogenerate is used in the load instruction to generate automatically rows in a table

hope this helps

Re: AutoNumber() vs Autogenerate()

Fri, 13 Feb 2015 10:24:47 GMT

Auto Number() :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.

Auto generate () :Autogenerate is a function that can be used with Load Statement in the script side. This function is used to generate specified number of rows using script.