order by clause from qvd load

Wed, 10 Jun 2009 16:06:44 GMT

Am I right in thinking QV can't use an 'order by' clause when loading from a qvd file?

I am sucking chunks of data from a large table by year so I end up with 2007.qvd 2008.qvd 2009.qvd. This is also good for incremental cos I can just grab 2009 when i want to refresh the data.

But, I need to suck all the qvd's into QV by customerid sort order because the load script is adding some fields which expect the customerid's to hit the load script in that order.

Sounds as though my only option is to load qvd's in default order then reload as resident and re-order then.

Any other clever ideas?

Thanks

order by clause from qvd load

Wed, 10 Jun 2009 17:52:49 GMT

Might be better this way, otherwise you would lose the Superfast mode in which QVDs load.

topic order by clause from qvd load in QlikView

order by clause from qvd load

order by clause from qvd load