Limited Data to be loading

[#1]

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 · Accepted solution]

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]

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