topic Limited Data to be loading in QlikView

Limited Data to be loading

Tue, 16 Aug 2011 09:23:36 GMT

Hi All,

I want to load limited rows from the data base how can i do that like want to load only 20 rows from above.

Jude,

its_anandrjs — Tue, 16 Aug 2011 09:26:33 GMT

Hi Jude,

You want to load a 20 rows to do this you need to conditionally load data and add a syntax in load script like

LOAD Column1,

Column2,

Column3

FROM

[DataFile.xls]

(ooxml, embedded labels, table is [DATA])

Where Recno()<=20;

martin59 — Tue, 16 Aug 2011 09:38:00 GMT

Hi,

You have to do something like that :

Table:
FIRST (20) // If you want to load the 20th first rows
LOAD * FROM MyTable;

Hope that helps you

Martin