how to create auto generate?

[Anonymous]

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]

Multiple locations ?? What you mean that AutoGenerate??

[Anonymous]

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

];