Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm new at this aaand I'm trying to create a new autogenerated table with 1000 clients. Every client needs to have an Unique ID from 1 to 1000 and his name needs to be "Client 1" for the first one, "Client 2" for the second, "Client 1000"... I tryed to create the "Client" as a string and after that to add the ID so I can get the right name, but that seems imposible.
That's my code:
Clients:
LOAD
AutoNumber(ID) as ID -> which is wrong, I dont have an ID field to give to AutoNumber
('Client'+ID) as Client -> whis cant work without the ID 😞
//concat('Client'&ID) as client
AUTOGENERATE
1000;
STORE Clients into [D:\Examples\Qlik\Clients.qvd] (qvd);
Thanks in advance for any suggestions and solutions!!!
Try like:
Clients:
LOAD
RowNo() as ID ,
'Client' & RowNo() as Client
AUTOGENERATE 1000;
Try like:
Clients:
LOAD
RowNo() as ID ,
'Client' & RowNo() as Client
AUTOGENERATE 1000;
Thank you!
Also, have a look at mockaroo.com... useful for creating sample datasets