Auto Number function

[Anonymous]

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

[adamwilson]

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,

eg

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

Region,

Year,

Month

From Table;

[#3]

hi Dhiraj

please find Attachment

and please go through  following  link 

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

[julian_rodriguez]

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...

1

2

3 ... .and so on...

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

Regards!

[Anonymous]

Hi   qliklearn,

Thanks for the reply I understood ...

[Anonymous]

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