topic Pulling 100 records from database having 1000000 in QlikView

Pulling 100 records from database having 1000000

Fri, 26 Jul 2013 07:49:02 GMT

Hi All,

Please any one help me to get the 100 records from 100000 records,

can we use the same Query in Qlikview ( select * from STG_EDW_ORD_DTL where rownum<=1000; )

thanks in advance,

Ram.

Miguel_Angel_Baeyens — Fri, 26 Jul 2013 07:52:17 GMT

Hi Ram,

Indeed, you can do it in several ways:

Table:
LOAD *
FROM File.qvd (qvd)
WHERE RecNo() <= 100; // depending on your script, you can also use RowNo()

Table:
FIRST 100 LOAD *
FROM File.qvd (qvd);

Hope that helps.

Miguel

VishalWaghole — Sun, 28 Jul 2013 08:02:27 GMT

Hi Ram,

Yes u can use query like

select * from STG_EDW_ORD_DTL where rownum<=100;

make qvd file for this table like

STG_EDW_ORD_DTL:

select * from STG_EDW_ORD_DTL where rownum<=100;

store STG_EDW_ORD_DTL into ../Qvds/STG_EDW_ORD_DTL.qvd;

Drop table STG_EDW_ORD_DTL;

and use this qvd file as ur table like

TABLE:

LoAD *

FROM STG_EDW_ORD_DTL.qvd(qvd)

Where RecNo() <= 100;

Thanks