Autogenerate names and ID's for 1000 clients

[SilcenceIv]

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!!!

[tresesco · Accepted solution]

Try like:

Clients:

LOAD

             RowNo() as ID ,

             'Client' & RowNo() as Client

AUTOGENERATE 1000;

[SilcenceIv]

Thank you!

[bismart]

Also, have a look at mockaroo.com... useful for creating sample datasets