Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just use autonumber(customer) as ID..
This is great. is there a way to specify the order when auto generate the ID?
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