Sort data in a cell

[sbfernandes]

Greetings! Is there any way to sort data in a cell (alphabetically). Eg: (attached pic) Contents of Col B is to be sorted individually.

[mrybalko]

Hello @sbfernandes 

Do you need new column on data loading stage or just chart expression?

[sbfernandes]

Hi Mrybalko

I require a new column in the loading stage.

Thanks.

[mrybalko · Accepted solution]

Data:
LOAD
	RowNo() as RowID,
	Unsorted
Inline [
Unsorted
'zebra,lion,tiger'
'oil,apple,butter'
];

tmp:
LOAD
	RowID,
	SubField(Unsorted, ',') as Values
Resident Data;

LEFT JOIN('Data')
LOAD
	RowID,
	Concat(Values, ',') as Sorted
Resident tmp
Group by RowID
Order by Values;

drop Table tmp;

[sbfernandes]

Hi Mrybalko,
Many thanks for this. Works perfectly.