Re: AutoNumberHash256 - Qlik Community

priyarane · ‎2017-05-25

Hi Community,

I am using below composite key but it is taking lot of time.

AutoNumberHash256(field1,field2,field3,field4,field5,field6,field7,field8,field9) as key

Please suggest is there any way to create key instead of above.

-Priya

ahaahaaha · ‎2017-05-25

Hi Priya,

May be as variant

Regards,

Andrey

prma7799 · ‎2017-05-25

U can try

prma7799 · ‎2017-05-25

From the QV Help file, which should be your first option:

autonumberhash128 ( expression {, expression} )

Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

Example:

autonumberhash128 ( Region, Year, Month )

Autonumberhash256 ( expression {, expression} )

Calculates a 256-bit hash of the combined input expression values and returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key. This function is only available as a script function.

Example:

Autonumberhash256 ( Region, Year, Month )

fkeuroglian · ‎2017-05-25

Pria how are you?

You can create:

AutoNumberHash256(field1,field2,field3,field4,field5,field6,field7,field8,field9) as key

Any of this will be create a key, but is more efficient us AUTONUMBER

Using this way, you will save a bit of memory.

AutonumberHash creates unique hashed numbers, however they are not sequential integers, therefore the memory savings will be substantially lower.

Hope Help

AutoNumberHash256

autonumberhash128( expression {, expression} )

Example:

Autonumberhash256( expression {, expression} )

Example:

autonumberhash128 ( expression {, expression} )

Autonumberhash256 ( expression {, expression} )