Hello!I have some table, for ex.
Field 'Sales' is calculated in expression and i need to sort it descending (not using Sort tab, because i'll work with sorted values further)
Thanks for answers!
The only way to do that is to do the sorting in the load script:
Load ID, Sales From ...mysource...;
Load ID, Sales Resident Temp
Order by Sales desc;
Drop Table Temp;
In the script use Order by function.................
Retrieving data ...