topic Re: how to create auto generate? in QlikView

how to create auto generate?

Anonymous — Thu, 28 Dec 2017 10:48:41 GMT

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

Anil_Babu_Samineni — Thu, 28 Dec 2017 10:51:39 GMT

Multiple locations ?? What you mean that AutoGenerate??

Anonymous — Thu, 28 Dec 2017 11:05:10 GMT

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 — Thu, 28 Dec 2017 11:12:51 GMT

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

];