Limit load

[kicchu465]

hi all,

I want to load only  few of the records from the DB

for example I have  1000 records  but I want to load from db  only 500 records

how to do this?

Thanks

[vishsaggi]

Why don't you do like

LOAD *;

SQL

SELECT TOP 500 fieldname1, fieldname2.....

FROM yoursource;

[el_aprendiz111]

Hi

1 option

First 1000
LOAD * FROM  [..\..\..\....

[its_anandrjs]

You have tried this

LOAD

*,

Where Rowno()  <= 1000;

SQL SELECT *

FROM DailyLogTable;

[its_anandrjs]

For 500 rows this

In SQL

LOAD

*,

Where Rowno()  <= 500;

SQL SELECT *

FROM DailyLogTable;

In Qlikview

1. Way

LOAD

*

Load From SourceTable

Where Rowno()  <= 500;

2. Way

First 500

Load

*

From Source;