loading records

[prabhas277]

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?

[Gysbert_Wassenaar]

Maybe like this:

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

LOAD *, RecNo() as RecNo;

SQL SELECT * FROM source_table;

[Anonymous]

May be  like this

Rec:

load RecNo() As Rec

, Record ;

LOAD * INLINE [

    Record

    10

    20

    30

    40

    50

    60

    70

    80

    90

    100

]

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

[prabhas277]

is it possible by using exists function?

[padmanabhan_ram]

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

[jagan]

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.

[qlikviewwizard]

Hi,

Please try like this:

Hope this will help you.

Script:

OUTPut: