Custom Sort at script level

[#1]

Dear All,

As qlikview loads the data bydefault in chronological order at script level, How can i change it to the load oder.

Because of this sorting , i am not able to get the exact data while applying concat function on 2 fields.

Ex: Source,Destination

       A, C

       D, F

       Z, Q

As per my requirement it should give :   Z-F/D-C/A-Q

But after concat it is giving :                 A-Q/D-C/Z-F

I have used the following formulae: concat((Source&'-'&Destination),'/')

Thanks in advance

[Anonymous]

One can sort with the order by clause of a resident load :

load

     Source,

     Destination

resident YourTable

order by Source, Destination ;

[anbu1984]

Load *,RowNo() As RowNo Inline [
Source,Destination
A, C
D, F
Z, Q ];

=concat((Source&'-'&Destination),'/',-RowNo)