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
STORE Clients into [D:\Examples\Qlik\Clients.qvd] (qvd);
Thanks in advance for any suggestions and solutions!!!