Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone i have a query and i am struck on this can someone help me regarding this .
Can i sort QVD without taking resident load and order by ??
can we use the concept of Bit stuffed pointers and symbol table in this ??
Hi @adiey_26
that is not possible,
you can read more about that -
Does order by not work in the load script? - Qlik Community - 1030927
Qlik Sense - Order by in load script - Qlik Community - 1298366
No, data cannot be sorted while it is being loaded in-memory
This is same as order or execution of a SQL, sort by is the second last clause to be executed
imagine this
Sorting after loading row1, then sort row1 ,2 after loading row2, then sort row1,2,3 after loading row 3 !!
Why not sorting the data before they are stored within the qvd?
- Marcus