topic Re: Load x amount of rows in QlikView

Load x amount of rows

Anonymous — Wed, 16 Sep 2015 16:26:22 GMT

I want to only load the last 10,000 rows in my data set, where Status='R'. Is there a simple way to do this?

Colin-Albert — Wed, 16 Sep 2015 16:52:36 GMT

Is there a date field to identify the most recent records?

If there is you could use something like

FIRST 10000

LOAD

... ;

SQL select

...

From ....

Where Status = 'R'

Order by your_date_field desc ;

Oleg_Troyansky — Wed, 16 Sep 2015 16:53:48 GMT

You can load the FIRST x number of rows :

FIRST 10000

LOAD ...

So, if you sorted your data in a descending order (based on a date/time, or an ID) then you could limit your load to the last x number of rows.

cheers,

Oleg Troyansky

Oleg_Troyansky — Wed, 16 Sep 2015 16:54:36 GMT

Jinx!

Anonymous — Wed, 16 Sep 2015 17:44:14 GMT

This works perfect. but the Load is loading the first 10,000 with and with out the 'Order by' statement.

I am Ordering by ROWID. in this case i get row 1-10000

Anonymous — Wed, 16 Sep 2015 18:04:40 GMT

I did order by -ROWID

that gave me the right answer.

Oleg_Troyansky — Wed, 16 Sep 2015 18:07:28 GMT

Have you tried ordering in descending order?

ORDER BY ROWID DESC

Anonymous — Wed, 16 Sep 2015 18:38:10 GMT

Just did. This also works. Thank you!