topic Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256? in QlikView

what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 11:27:16 GMT

what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

when to use autonumber?

autonumberhash128?

autonumber256?

pls tell me help document is not useful explain me with some sample scenario?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 11:37:39 GMT

hi,

autonumber stores the expression value and gives it a unique integer value whereas autonumberhash128 stores just the hash value (in 128 bits) of the corresponding expression value. similarly autonumberhash256 stores the value (in 256 bits) of the corresponding expression value.

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 11:51:15 GMT

can u give explination with small example pls

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 15:13:14 GMT

There functions available in Script level only. We can create Integer Instead of big strings formed by composite keys,

Ex: LOAD AutoNumber(Field1 & '-' & Field2 & '-' & Field3) AS KEY_FIELD

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

ThornOfCrowns — Mon, 07 Jul 2014 15:21:24 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: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 15:54:43 GMT

give some other example not from help document pls

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Mon, 07 Jul 2014 20:11:49 GMT

Try the these functions in your Sample qvw file and let us know if you don't understand

topic Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256? in QlikView

what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

autonumberhash128( expression {, expression} )

Example:

Autonumberhash256( expression {, expression} )

Example:

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

Re: what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?

autonumberhash128 ( expression {, expression} )

Autonumberhash256 ( expression {, expression} )