Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know if there is a shortcut to determine an autonumber on all fields in a record without having to add all fields in the autonumber statement?
autonumber(Field1&Field2&....) as Checksum
autonumber(*) as Checksum (which is not working)
hi,
The purpose of autonumber function is to generate hashcode number from an input string.
that's why there is no shotcurt for all fields , you must add '&' between fields name .
NB :
We use this function in qlikview's script to avoid loops between two table ,by creating one field for multiple common fields between two table . So , if your purpose is to avoid loops there is no need to create autonumber for all fields ( in this case two table contain exactly the same name of attribute , so please use qualify and unqualify ) .