Sort without using Sort Tab

[Anonymous]

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!

[Gysbert_Wassenaar · Accepted solution]

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;

[Anonymous]

Try like

In the script use Order by function.................