topic Re: autonumberhash fun? in QlikView

autonumberhash fun?

Wed, 29 Oct 2014 18:37:22 GMT

i have usedin this application autonumber function and autonumberhas128,256 but

it is giving same result no change in output . then what is the difference between autonumber function

and autonumberhas128,256 ? and when to use each one ?

Re: autonumberhash fun?

ashfaq_haseeb — Wed, 29 Oct 2014 19:08:29 GMT

Hi,

Yes it will give same answer.

The only difference will be in data handling

Example

AutoHash128(): a 128 bit hash function that returns a 22 character string.

AutoHash256(): a 256 bit hash function that returns a 43 character string.

So if you have strings more then 22 character then go with AutoHash256().

Hope its clear.

Regards

ASHFAQ

Re: autonumberhash fun?

its_anandrjs — Wed, 29 Oct 2014 19:29:05 GMT

Hi,

There is difference in the use of the Autonumberhash128 and Autonumberhash256 and it is depends on the key values and combination used in the data model. And how complex your key fields that use in which type of the Autonumberhash

Ex:-

Autonumberhash128 calculates the 128-bit hash of the combined input and it is make complex key where as

Autonumberhash256 calculates the 256-bit hash of the key used in the function and Both returns the integer keys.

Regards

Anand