Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
No ... Order by works only in Residential load ...
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.
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
hi
try this
Load … from customer.qvd(qvd)
Order by [Order_DT_Ev.] asc ;
Hi Raja,
Here is a trick
Load * Order By FieldName;
Load ...
from customer.qvd (qvd);
Regards,
Sokkorn
Hi Kumar,
Thanks for your quick response.
I attempt your script but I am unsuccessful customer is not ascending order.
Regards,
Raja.
Hi Sokkom,
Thanks for your quick response.
Regards.
Raja.
Hi Luis,
Thanks for your quick response.