Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

farolito20
New Contributor III

AutonumberHash

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: AutonumberHash

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.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: AutonumberHash

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.


talk is cheap, supply exceeds demand
farolito20
New Contributor III

Re: AutonumberHash

Thanks

MVP & Luminary
MVP & Luminary

Re: AutonumberHash

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

Community Browser