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 |
