Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
scenario,i have one table in billon row,
i want only in 100 row in qlikview
wt way...?
without using where condition...?
Thanks&Regard
Mahindra
Open Script Editor, click Debug... A debugger window opens. On the left, you'll find a configurable selection to load only a limited number of rows. Select 100 and click Run...
Add FIRST 100 before the load command.
First 100
Load.....
If you need any 100 rows, then use Top if it is available in your database
Select Top 100 From Table;