What is the difference between Autonumber and Autonumberhash?

[jblomqvist]

Hello,

Can anybody please tell me what is the difference between Autonumber and Autonumberhash in QlikView?

I understand much better with a example so if anyone can show the difference it would be great please!

[jonathandienst]

All the Autonumbering functions guarantee the correctness of the numbers within a single load. A subsequent load may not produce the same values, so they cannot be used as a meaningful key in a QVD intended for subsequent reloading and combining with other data (eg an incremental load)

[anderseriksson]

Just a little correction for Rob's first example, the second 'A' would get the same number as the first 'A'.

AutoNumber('A') = 1

AutoNumber('X') = 2

AutoNumber('A') = 1

AutoNumber produces the same output every time for the same input as long as you are in one QVW.