Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Order By on a resident table doesn't work. Why?
[TABLE]:
LOAD ID, AMOUNT
From [C:\Users\User\Desktop\test.xlsx]
(ooxml, embedded labels);
[final_TABLE]:
NoConcatenate
LOAD ID, AMOUNT
Resident TABLE
Order by AMOUNT desc;
DROP Table TABLE;
---
This script retuns:
the order in the load script allows you to apply the order in the internal table of QLikview (preview)
in UI you can use :
the order in the load script allows you to apply the order in the internal table of QLikview (preview)
in UI you can use :
Taoufiq_ZARRA, Thank you so much for your help.