Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why don't you do like
LOAD *;
SQL
SELECT TOP 500 fieldname1, fieldname2.....
FROM yoursource;
Hi
1 option
First 1000
LOAD * FROM [..\..\..\....
You have tried this
LOAD
*,
Where Rowno() <= 1000;
SQL SELECT *
FROM DailyLogTable;
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;