Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load 1 to 100 without Recno() or Autogenrate


Hi,

Is this possible to load 1 t0 100 without Recno() or Autogenerate

I know we can do with...    Load RecNo( ) as A autogenerate(100);

but

someting Like

i=1;
for i= 1 to 100;
load i as ID;
next i

1 Solution

Accepted Solutions
rwunderlich

You can do it just as you described, but you sill need a data source -- which can be the AUTOGENERATE keyword.

i=1;

for i= 1 to 100;

load $(i) as ID autogenerate 1;

next i

-Rob

View solution in original post

4 Replies
peschu123
Partner - Creator III
Partner - Creator III

Can you use:

FIRST(100) LOAD

..

..

..

FROM ... ;

Regards Peter

rustyfishbones
Master II
Master II

do you mean like

FIRST 100, will only load the first 100 rows from the source data

LIKE THIS

2014-03-10_1426.png

rwunderlich

You can do it just as you described, but you sill need a data source -- which can be the AUTOGENERATE keyword.

i=1;

for i= 1 to 100;

load $(i) as ID autogenerate 1;

next i

-Rob

Not applicable
Author

So still we need to use autogenrate!

I am thinking some thing similar in VB.

Thanks Rob,

Vinay