topic Re: autogenerate unique id for distinct values in QlikView

autogenerate unique id for distinct values

yelin_nyu — Thu, 02 Jan 2014 17:00:24 GMT

I need to generate an ID for each customer from detail table. meaning there are multiple records per customer.

here is what I did

load distinct customer

rowno() as ID

from detail_table

order by customer;

rather than getting

customer ID

Abbie 1

Bill 2

Cathy 3

I got this

customer ID

Abbie 1

Abbie 2

Abbie 3

Abbie 4

Bill 5

Bill 6

Bill 7

Cathy 8

rbecher — Thu, 02 Jan 2014 17:04:17 GMT

Just use autonumber(customer) as ID..

yelin_nyu — Thu, 02 Jan 2014 17:07:44 GMT

This is great. is there a way to specify the order when auto generate the ID?

Thu, 02 Jan 2014 17:12:32 GMT

Customer_deatils:

LOAD * Inline [

customer, ID

Abbie, 1

Abbie, 2

Abbie, 3

Abbie, 4

Bill, 5

Bill, 6

Bill, 7

Cathy, 8

];

LOAD customer,AutoNumber(ID) as uni_id Resident Customer_deatils