Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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.