Hi,
AutoNumber () generates sequential integers, AutoNumber stores the expression value and gives it a unique integer value. This function can be used e.g. for creating a compact memory representation of a complex key.
The Autonumber() function is used on the composite keys, It replaces long strings with a short number while maintaining all information. Which is a very storage efficient data for Qlikview.
If you have two are more common fields between tables, which are Unavoidable. Then you need to create composite keys between tables, i.e. keys that are concatenations of several other keys.
AutoID – When autonumbering different key fields in the same script, you should use the AutoId parameter. This ensures that each field will have sequential numbers with no gaps. Its Normally we use the fieldname as AutoId.
Syntax:
AutoNumber (expression [, AutoID])
Example:
LOAD AutoNumber (Product & Region, 'Key') AS KEY_FIELD
Regards
Neetha
