grouping in qlikview

[#1]

lat1	MSISDN
1.3098	525-00-10001
1.3098	525-00-10003
1.3224	525-00-10002
1.3224	525-00-10004
1.3526	525-00-10002
1.3526	525-00-10004
1.3669	525-00-10001
1.3669	525-00-10003

hi all,

I had a table like specified above. i want to get the output like this

user                              group no

525-00-10001              1

525-00-10003               1

525-00-10002                   2

525-00-10004                    2

i want to get this from script

please let me know how to do this

[#2]

Hi

Try this

Load Autonumber(Lat1) as Group, MSISDN as user resident tablename;

Regards,

Arun