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 |