topic Re: Sorting in QlikView

Sorting

brindlogcool — Thu, 22 Aug 2013 16:53:55 GMT

Hi,

I am trying to sort the text in the load script. But is not getting sorted. Added the sample script

LOAD * INLINE [
Id, Country
6, India
1, India
2, Austraila
3, England
4, UK
5, USA
];

T1:
NoConcatenate
Load
*
Resident T order by Country asc;

Drop Table T;

Re: Sorting

Anonymous — Thu, 22 Aug 2013 16:58:39 GMT

click sort-text-a-z/z-a

Re: Sorting

Gysbert_Wassenaar — Thu, 22 Aug 2013 17:49:30 GMT

That's because the load order of Country is determined by the first load statement. The second table will be ordered by Country so you can use that order for calculations. But the field Country in the in-memory database will still be sorted in the load order of table T1. What you can do is create a new field Country_Temp and later rename it:

LOAD * INLINE [
Id, Country
6, India
1, India
2, Austraila
3, England
4, UK
5, USA
];

T1:
NoConcatenate
Load
Id, Country as Country_Temp
Resident T order by Country asc;

Drop Table T;

Rename Field Country_Temp to Country;

Re: Sorting

brindlogcool — Thu, 22 Aug 2013 20:31:23 GMT

Thanks G Wassesnaar,

Really appreciate your response and got the clarification. Since we cannot use the sort by QVD load. I will try out your way and let you know.