topic Re: Autonumberhash128 in QlikView

Autonumberhash128

brindlogcool — Mon, 23 Jan 2012 02:28:06 GMT

Hi,

i am trying to use Autonumberhash128 to reduce the field space which is the combination of character&number . Intially the size of the Key field was 1gb and after using the autonumberhash128 is almost the same i couldnt see the change in the size of the field.

Re: Autonumberhash128

rwunderlich — Mon, 23 Jan 2012 05:23:01 GMT

If the keys are created in the same script run (meaning not stored in a qvd) then use

autonumber(character & '|' & number)

autonumberHash128(character,number)

Either of those will generate sequential integer keys which will be much smaller. Both should give you the same result.

-Rob

http://robwunderlich.com

Re: Autonumberhash128

brindlogcool — Tue, 24 Jan 2012 20:37:48 GMT

Thanks Rob,

Can you explain in more detail what you refer meaning not stored in QVD.

Re: Autonumberhash128

rwunderlich — Wed, 25 Jan 2012 03:22:16 GMT

What I should have said is not being stored in a QVD that is later updated by an incremental load. If you are generating the complete set of keys every run then it's fine to store them in a QVD.

If you are updating only some rows in the QVD using incremental load, then storing the keys would give incorrect results. The update rows would begin autonumbering from 1 again and you would have duplicate keys. If you are not doing incremental loads, no worries.

-Rob

Re: Autonumberhash128

brindlogcool — Wed, 25 Jan 2012 03:48:08 GMT

Thanks it was really useful.

Re: Autonumberhash128

brindlogcool — Wed, 25 Jan 2012 15:16:27 GMT

Hi Rob,

I was testing the Autonumber & Autonumberhash128 for a field which is combination of specical character,String and number, Where the Autonumber is working fine, but the Autonumberhash128 is not working as it should.

The first record (Serial number 1) is not having any values in the Autohashnumber128. I am not sure why the Autonumberhash128 is start with the blank record .I am not sure where i am missing .

This is how it looks

ColumnA ActualColumn GeneratedKey(Autonumberhash128)

- - 1

123 Test|123 2

But i didnt see the blank record in the Autonumber.

Another issue popped up,i have generated a key using Automber and stored in a QVD. Genereated one more QVD with Automber and trying to Compare with previous one. I am validating the resutls to find anythings i have missed. Mean time i would like to know any other restrictions other than Incremental reload.

Re: Autonumberhash128

brindlogcool — Wed, 25 Jan 2012 22:30:08 GMT

Hi Rob,

Issue is resolved and the Autonumber or Autohashnumber will not be solution for my problem. Thanks for your responses

Re: Autonumberhash128

Tue, 08 May 2012 04:39:53 GMT

Hi,

Does anyone know how can i autonumber with condition. meaning, i want it to recount at the condition i set eg, in the if statement.

for the moment, it keeps the number continuously.

thanks.

Re: Autonumberhash128

rwunderlich — Tue, 08 May 2012 16:42:02 GMT

Use the second param of autonumber. If this is a new value, the numbering starts over.

-Rob