topic Re: Load from Sql database in QlikView

Load from Sql database

gidon500 — Tue, 08 Apr 2014 18:39:46 GMT

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

its_anandrjs — Tue, 08 Apr 2014 18:45:43 GMT

Load your table like

Load

Statements

...

From Location

Where RecNo( ) > 3500000;

Regards

its_anandrjs — Tue, 08 Apr 2014 18:50:35 GMT

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

maxgro — Tue, 08 Apr 2014 19:13:09 GMT

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;