Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Load from Sql database

Hello

i have an SQL table with App 4,000,000 lines

i want to start the load fro line 3500000

how can i do it with out a condition in the load script ,

thanks

gidon

Tags (1)
3 Replies
Highlighted

Re: Load from Sql database

Load your table like

Load

Statements

..

...

From Location

Where RecNo( ) > 3500000;

Regards

Highlighted

Re: Load from Sql database

For your SQL load statement write a code like

LOAD Region, Country Where RecNo() > 3500000;

SQL SELECT Region, Country

FROM Emp;

Write this statement Where RecNo() > 3500000

Highlighted
MVP
MVP

Re: Load from Sql database

if you want the filter in sql server, I think

Table:

load

  *;

SQL

select * from (

SELECT ROW_NUMBER() OVER (

   ORDER BY (SELECT 1)) AS RowNumber, 

*

FROM YourSqlServerTable

) a

where RowNumber > 3500000;