Discussion board where members can get started with QlikView.
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?
Why don't you do like
SELECT TOP 500 fieldname1, fieldname2.....
First 1000 LOAD * FROM [..\..\..\....
You have tried this
Where Rowno() <= 1000;
SQL SELECT *
For 500 rows this
Where Rowno() <= 500;
Load From SourceTable