AutoNumber for linking column

Mon, 22 Dec 2014 19:10:59 GMT

Hi All,

What is the meaning of the below code in script? What it will do?

LOAD AutoNumber(Item_Desc & Sub_Item_Desc) as %LinkItemDesc,

Thanks in advance.

Re: AutoNumber for linking column

Anonymous — Mon, 22 Dec 2014 19:37:53 GMT

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

topic AutoNumber for linking column in QlikView

AutoNumber for linking column

Re: AutoNumber for linking column