Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AutoNumber() vs Autogenerate()

Hello,

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

Thanks,

Uday.

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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.