How about this way (sample QVW attached).
Freight1 + Freight2 as TotalFreight
LOAD * INLINE [
Place Warehouse Source Freight1 Freight2
P1 WH1 S1 100 10 110
P1 WH1 S2 200 20 220
P1 WH2 S1 200 10 210
P2 WH2 S1 300 20 320
P2 WH2 S2 400 10 410
] (delimiter is '\t')
'L' & AutoNumber(TotalFreight, Place) as Classification
order by TotalFreight
DROP TABLE data; // Drop orginal table
RankSum_82335.qvw 150.5 K
Thanks a lot Rob and Sushil..
Both answers are of same logic
I checked the reference manual for AUTONUMBER. But I could not understand the logic behind its working.
Could you please help me with that?
Is there some way using functions like AGGR or MIN and GROUP BY?
Its for better understanding. Nothing else.
Autonumber generate the counter based on the expression passed in the autonumber.. in this particular case we have passed the field name... that means for each field value it will generate a number...
now the second parameter is used to reset the counter based on the instance of the second parameter...
in this case we have to reset our counter for each Place type..
now at last we are using order by clause to put the right counter value from top to lower records..
Hope the explanation helped you to understood the functionality of autonumber.