topic Re: Auto Number function in QlikView

Auto Number function

Anonymous — Mon, 24 Feb 2014 14:06:31 GMT

Hi Everyone ,

Anyone please give me a scenario where we can apply the auto number() function with example.

I'm not getting how to use auto number() function and howz it work.

Thanks

Re: Auto Number function

adamwilson — Mon, 24 Feb 2014 14:13:17 GMT

If you have a key fields which is long or made up of several fields one way to make them shorter and less memory consuming is to use autonumber to assign an integer rather then a string,

Load autonumber( Region&Year&Month, 'Ctr1' ) as %Key,

Region,

Year,

Month

From Table;

Re: Auto Number function

Mon, 24 Feb 2014 14:14:20 GMT

hi Dhiraj

please find Attachment

and please go through following link

Qlikview Notes: Autonumber() Key Fields and Sequential Integer Optimization

Re: Auto Number function

julian_rodriguez — Mon, 24 Feb 2014 14:16:48 GMT

Hello Dhiraj,

Autonumber function is very useful mostly for a data model's memory reduction.

For example, if your model has a key like %Pk_Customer_Product_City with 1,000,000 of different values like:

10010010_980099002_New York

10310010_980069002_London.... and so on...

Now, you may consider using autonumber(%Pk_Customer_Product_City) As %Pk_Customer_Product_City and it will change each distinct value for a different integer value...

3 ... .and so on...

In summary, I have used this function in order to reduce the memory usage, mainly with the PK fields.

Regards!

Re: Auto Number function

Anonymous — Mon, 24 Feb 2014 14:19:49 GMT

Hi qliklearn,

Thanks for the reply I understood ...

Re: Auto Number function

Anonymous — Mon, 24 Feb 2014 14:22:20 GMT

Thanks a lot julian for the reply .....