topic Re: AutonumberHash in QlikView

AutonumberHash

farolito20 — Wed, 02 Jan 2013 21:39:00 GMT

Exist a way to know which columns compose a AutonumberHash?

I need this because I probably add a new column to my key, and I need update the rows without the new key.

Re: AutonumberHash

Gysbert_Wassenaar — Thu, 03 Jan 2013 19:39:53 GMT

Yes, look in the script at the fields you use in the autonumberhash function. That's the only way. Only the number is stored, not which fields were used to generate the number. That information exists only in the script.

Re: AutonumberHash

farolito20 — Thu, 03 Jan 2013 19:53:44 GMT

Thanks

Re: AutonumberHash

rwunderlich — Thu, 03 Jan 2013 20:03:01 GMT

If you are using AutonumberHash(), then you must regeneratate the key(s) and update every row on every script run anyways. You can't reliably reuse a previously stored autonumber() value.

If you are using the hash() functions, you can use previously stored values.

-Rob