topic Re: Load 1 to 100 without Recno() or Autogenrate in QlikView

Load 1 to 100 without Recno() or Autogenrate

Mon, 10 Mar 2014 14:24:05 GMT

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

peschu123 — Mon, 10 Mar 2014 14:25:32 GMT

Can you use:

FIRST(100) LOAD

FROM ... ;

Regards Peter

rustyfishbones — Mon, 10 Mar 2014 14:26:25 GMT

do you mean like

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

LIKE THIS

rwunderlich — Mon, 10 Mar 2014 14:29:43 GMT

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

Mon, 10 Mar 2014 14:36:41 GMT

So still we need to use autogenrate!

I am thinking some thing similar in VB.

Thanks Rob,

Vinay