I have a dataset as
| Name | Period | Month | Month_Order | 
| Mango | Jan_2020 | Jan | 1 | 
| Apple | Apr_2020 | Apr | 4 | 
| Mango | Feb_2020 | Feb | 2 | 
| Orange | Jan_2020 | Jan | 1 | 
| Peach | Feb_2020 | Feb | 2 | 
| Apple | Mar_2020 | Mar | 3 | 
| Apple | Feb_2020 | Feb | 2 | 
| Mango | Apr_2020 | Apr | 4 | 
| Guava | Feb_2020 | Feb | 2 | 
| Guava | Jan_2020 | Jan | 1 | 
| Mango | Mar_2020 | Mar | 3 | 
And I want to sort it basis name first and then Month Order as below result:
| Name | Period | Month | Month_Order | 
| Apple | Feb_2020 | Feb | 2 | 
| Apple | Mar_2020 | Mar | 3 | 
| Apple | Apr_2020 | Apr | 4 | 
| Guava | Jan_2020 | Jan | 1 | 
| Guava | Feb_2020 | Feb | 2 | 
| Mango | Jan_2020 | Jan | 1 | 
| Mango | Feb_2020 | Feb | 2 | 
| Mango | Mar_2020 | Mar | 3 | 
| Mango | Apr_2020 | Apr | 4 | 
| Orange | Jan_2020 | Jan | 1 | 
| Peach | Feb_2020 | Feb | 2 | 
Solved! Go to Solution.
thank you so much Brandon for your quick reply.
Now i see what you mean.
Do we have a way to sort the column Units the same order as column Solde des actions ? ( I started with Alteryx not long ago..still new with these tools)
You probably notice that my first 2 columns are in French and the last 3 column are in English. They come from 2 different sources and I match them with Join Tool ( by using N de compte and Intermediary Acc. Code Fields) .
I' appreciate your helps.
Anh
HI BrandonB ,
I am stuck in a workflow using sorting tool. Appreciate if you can help.
A JUL 1
B DEC 2
A JAN 4
B SEP 3
| Name | Month | Salary | 
| a | jul | 1 | 
| b | dec | 2 | 
| a | jan | 3 | 
| b | sep | 4 | 
expected output:
| Name | Month | Salary | 
| b | dec | 2 | 
| b | sep | 4 | 
| a | jul | 1 | 
| a | jan | 3 | 
 
					
				
				
			
		
