Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Arranging words in a cell in alphabetical order

simasarry123
8 - Asteroid

I have designed a workflow that combines two separate datasets [set 1 and set 2 (name of countries)  to generate an output column. My requirement is that the output column should have the countries name in alphabetical order. How can I achieve this ? I have already used sort tool in the individual data set to sort in alphabetical order so while column 1 and column 2 are in alphabetical order but when i use a formula tool to arrive at the combined column =  [set 1] + [set 2] , i am unable to get these in A- Z order .

2 REPLIES 2
MilindG
12 - Quasar
simasarry123
8 - Asteroid

Thank you, let me try to apply this to my workflow and revert.

Labels
Top Solution Authors