topic Re: AutoNumberHash256 in QlikView

AutoNumberHash256

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: AutoNumberHash256

ahaahaaha — Thu, 25 May 2017 12:26:33 GMT

Hi Priya,

May be as variant

Regards,

Andrey

Re: AutoNumberHash256

prma7799 — Thu, 25 May 2017 12:36:15 GMT

U can try

Re: AutoNumberHash256

prma7799 — Thu, 25 May 2017 12:38:10 GMT

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 )

Re: AutoNumberHash256

fkeuroglian — Thu, 25 May 2017 12:39:41 GMT

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

topic Re: AutoNumberHash256 in QlikView

AutoNumberHash256

Re: AutoNumberHash256

Re: AutoNumberHash256

Re: AutoNumberHash256

autonumberhash128( expression {, expression} )

Example:

Autonumberhash256( expression {, expression} )

Example:

Re: AutoNumberHash256

autonumberhash128 ( expression {, expression} )

Autonumberhash256 ( expression {, expression} )