topic Re: loading records in QlikView

loading records

prabhas277 — Wed, 09 Sep 2015 05:14:07 GMT

Hi Experts,

I have 1 table in that 100 records are there now my req is load 20 to 30 records ,50 to 60,70 to 80 how i can get it?

Re: loading records

Gysbert_Wassenaar — Wed, 09 Sep 2015 05:18:52 GMT

Maybe like this:

LOAD * WHERE match(left(RecNo,1),'2','5','7')

LOAD *, RecNo() as RecNo;

SQL SELECT * FROM source_table;

Re: loading records

Anonymous — Wed, 09 Sep 2015 05:48:42 GMT

May be like this

Rec:

load RecNo() As Rec

, Record ;

LOAD * INLINE [

Record

100

]

Where RecNo()> 4 and RecNo() <7 or RecNo() >1 and RecNo()<3;

Re: loading records

prabhas277 — Wed, 09 Sep 2015 08:36:34 GMT

is it possible by using exists function?

Re: loading records

padmanabhan_ram — Wed, 09 Sep 2015 08:44:09 GMT

Hi Prabhas,

you can do it in many ways.

one of the way is introduce recno() in the load table and in the resident load use a where condition with the

(recno() >=20 and recno()<=30) and

(recno() >=50 and recno()<=60) and

(recno() >=70 and recno()<=80);

else you can use the values that are to be loaded in an inline table ans use that in the where exists().

hope this helps.

thanks,

Padmanabhan

Re: loading records

jagan — Wed, 09 Sep 2015 08:52:39 GMT

Hi,

Try like this

LOAD

FROM DataSource

WHERE (RecNo() >=20 AND RecNo() <=30) OR (RecNo() >=50 AND RecNo() <=60) OR (RecNo() >=70 AND RecNo() <=80) ;

It is not possible with Exists, if you want to use Exists() then you have load this numbers in another and need to use that column in Exists.

Regards,

Jagan.

Re: loading records

qlikviewwizard — Wed, 09 Sep 2015 08:53:59 GMT

Hi,

Please try like this:

Hope this will help you.

Script:

OUTPut: