topic order in load from QVD in QlikView

order in load from QVD

Mon, 04 Jun 2012 17:59:11 GMT

Hi,

could you tell me if I can use order by clause in Load statement from QVD?

(that make me an error).

Thanks

order in load from QVD

Oleg_Troyansky — Mon, 04 Jun 2012 18:05:50 GMT

You should be able to... If it's a large QVD, the load becomes not optimized though, so you might be better off loading the QVD with no order by, and then reloading in memory with the sorting options.

You might be getting an error if you are adding the Order By before the qualifier (qvd), or if one of your field names is misspelled.

Otherwise, it should work...

cheers,

Oleg

Re: order in load from QVD

Tue, 18 Jun 2013 03:52:59 GMT

ORDER BY does not work when directly loading from a QVD file.

You need to load it into a temp table, then sort in a second load from the resident table. Be sure to use NoConcatenate in the second load, so the tables aren't combined.