Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
Creator
Creator

Limit load

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

4 Replies
vishsaggi
Champion III
Champion III

Why don't you do like

LOAD *;

SQL

SELECT TOP 500 fieldname1, fieldname2.....

FROM yoursource;

el_aprendiz111
Specialist
Specialist

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;