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 .
Solved! Go to Solution.
Thank you, let me try to apply this to my workflow and revert.