Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna4bo
Creator
Creator

how to create auto generate?

Hi All,

How to create sample data with autogenerate function .

Ex: Userids with multiple locations up to 1000 rows

User_id,Location

1001,USA

1002,US

Thanks,

Krishna

3 Replies
Anil_Babu_Samineni

Multiple locations ?? What you mean that AutoGenerate??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishna4bo
Creator
Creator
Author

Hi Anil,

we can generate one fileld, i need 2 fields.

User_ID,Location

!001,Texas
1002,Florida
1101,Rome

1010,Bern

up to1000rows

Script:

LOAD

     999 + RecNo() AS User_ID

     AUTOGENERATE

     1000;


Thanks,

Krishna

Anil_Babu_Samineni

May be this?

Load Chr(RecNo()+Ord('Location')-1) as Location, RecNo()+1000 as User_ID autogenerate 100;

LOAD * Inline [

User_ID,Location

1001,Texas

1002,Florida

1101,Rome

1010,Bern

];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)