Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
SilcenceIv
Contributor
Contributor

Autogenerate names and ID's for 1000 clients

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

 

 

Labels (2)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Clients:

LOAD

             RowNo() as ID ,

             'Client' RowNo() as Client

AUTOGENERATE 1000;

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

Clients:

LOAD

             RowNo() as ID ,

             'Client' RowNo() as Client

AUTOGENERATE 1000;

SilcenceIv
Contributor
Contributor
Author

Thank you!

bismart
Creator
Creator

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