Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD file Sorting order.

Hi All,

When i am reading(loading) data from QVD files, Sorting (Order by <Column Name>) possible?. i am not using into Residential load.

For Ex,

Load … from customer.qvd(qvd)

Order by Order_DT_Ev.

Regards,

Raja.

8 Replies
Not applicable
Author

No ... Order by works only in Residential load ...

luis_pimentel
Partner - Creator III
Partner - Creator III

Hi,

You can use order by only in Resident load only.  If you want to use order by then load QVD data into temporary table and then using resident load sort the data and then drop the temporary table.  Check the script below

TempTable:

LOAD

     *

FROM FileName.QVD (qvd);

Data:

LOAD

     *

RESIDENT TempTable

ORDER BY Field1, Field2;

DROP TABLE TempTable;

Hope this helps you.

Regards,

Luis.

agilos_mla
Partner - Creator III
Partner - Creator III

Sorting (ORDER BY) is only possible with Resident (already in memory) files.

Sorting is not possible when reading from files.


You could add a sort order before Storing the data in the QVD.


Michael

Not applicable
Author

hi

try this

Load … from customer.qvd(qvd)

Order by [Order_DT_Ev.] asc  ;

Sokkorn
Master
Master

Hi Raja,

Here is a trick

Load * Order By FieldName;

Load ...

from customer.qvd (qvd);


Regards,

Sokkorn

Not applicable
Author

Hi Kumar,

Thanks for your quick response.

I attempt your script but I am unsuccessful customer is not ascending order.


Regards,

Raja.

Not applicable
Author

Hi Sokkom,

Thanks for your quick response.

Regards.

Raja.

Not applicable
Author

Hi Luis,

Thanks for your quick response.