Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load QVD order by a field

Good morning, I have this script to load a table:

load

 

* from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

 

It works correctly but I would need to get the resulting table oredered by a field called 'FECHA' and I'm not able to write the right sintaxis.

 

Can anyboy help me please?

Thanks

4 Replies
mvluttge
Partner
Partner

HI,

You have to resident load your actual-table.

The load you have now is fine (perhaps name the tabel "<tabelname>_TMP", or so), but then afterwards, you do a resident load on your "_tmp" table. Here you are able to order by which field you like.

I hope it helps

/Martin

robertomedellin
Contributor III
Contributor III

As Martin Says.

First:

TablaTemp:

load

  * from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

Then:

TablaFinalOrdenada:

load

*

resident TablaTemp Order By Fecha Asc;

Asc is ascending, desc would be newest first. And Drop Table Tabla Temp;

maxgro
MVP
MVP

add a noconcatenate to Roberto answer

TablaTemp:

load

    *     

from

     \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

TablaFinalOrdenada:

noconcatenate load

     *

resident TablaTemp Order By FECHA;

Drop Table Tabla Temp;

robertomedellin
Contributor III
Contributor III

Yes. Sorry Thanks Massimo. I had forgotten.