topic How to load QVD order by a field in QlikView

How to load QVD order by a field

Mon, 24 Sep 2012 08:22:58 GMT

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

Re: How to load QVD order by a field

mvluttge — Mon, 24 Sep 2012 08:35:04 GMT

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

Re: How to load QVD order by a field

Anonymous — Wed, 13 Aug 2014 16:47:33 GMT

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;

Re: How to load QVD order by a field

maxgro — Wed, 13 Aug 2014 17:04:53 GMT

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;

Re: How to load QVD order by a field

Anonymous — Wed, 13 Aug 2014 17:15:47 GMT

Yes. Sorry Thanks Massimo. I had forgotten.