Discussion Board for collaboration related to QlikView App Development.
I have requirement as such:
The original column has values like:
I want to sort this and get the final output as:
Whats the way to do this and efficiently , as actual data is much bigger.
'['&Concat(Num, '][', Num)&']' as Num
Group By FieldA ;
Purgechar(SubField(FieldA, ']['),'][') as Num
You could use something like this:
t0: load keepchar(subfield(FieldA, ']['), '0123456789') as FieldA from Source;
t1: noconcatenate load '[' & concat(FieldA, '][', FieldA) ']' as FieldA resident t0;
drop tables t0;
Thanks Marcus and Tresesco. Let me try these and get back.