autogenerate unique id for distinct values

[yelin_nyu]

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 · Accepted solution]

Just use autonumber(customer) as ID..

[yelin_nyu]

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

[#4]

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