Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I´m trying to find a solution to do a sort inside the string, but I´m newbie in Qlik and I don´t know how to solve this problem.
I´m using Qlikview 12 Personal Edition.
Example: Imagine a table, where exist a field called "Name". Now, I want to create an expression that take every string in the "Name" field and do a sort in it as "Name_Sorted". Please, look at the table below.
Name | Name_Sorted |
---|---|
josep | ejops |
john | hjno |
maria | aaimr |
fedcba | abcdef |
Any suggestions on how to do this?
Thank you and sorry for my english.
Diego
Maybe
LOAD RecId, Concat(Char) as Sorted,
Name
GROUP BY RecId,Name;
LOAD Mid(Name,iterno(),1) as Char,
Iterno() as Index,
Recno() as RecId,
Name
WHILE iterno() <= Len(Name);
LOAD Name
FROM
[https://community.qlik.com/thread/233512]
(html, codepage is 1252, embedded labels, table is @1);
Maybe
LOAD RecId, Concat(Char) as Sorted,
Name
GROUP BY RecId,Name;
LOAD Mid(Name,iterno(),1) as Char,
Iterno() as Index,
Recno() as RecId,
Name
WHILE iterno() <= Len(Name);
LOAD Name
FROM
[https://community.qlik.com/thread/233512]
(html, codepage is 1252, embedded labels, table is @1);
Hi Stefan,
It worked great.
Thank you.