Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One can sort with the order by clause of a resident load :
load
Source,
Destination
resident YourTable
order by Source, Destination ;
Load *,RowNo() As RowNo Inline [
Source,Destination
A, C
D, F
Z, Q ];
=concat((Source&'-'&Destination),'/',-RowNo)