Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have some table, for ex.
ID Sales
1 30
2 40
3 20
4 5
5 15
6 16
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:
Temp:
Load ID, Sales From ...mysource...;
Result:
Noconcatenate
Load ID, Sales Resident Temp
Order by Sales desc;
Drop Table Temp;
The only way to do that is to do the sorting in the load script:
Temp:
Load ID, Sales From ...mysource...;
Result:
Noconcatenate
Load ID, Sales Resident Temp
Order by Sales desc;
Drop Table Temp;
Try like
In the script use Order by function.................