Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Sort Multiple columns

SamSurya
8 - Asteroid

I have a dataset as 

 

NamePeriodMonthMonth_Order
MangoJan_2020Jan1
AppleApr_2020Apr4
MangoFeb_2020Feb2
OrangeJan_2020Jan1
PeachFeb_2020Feb2
AppleMar_2020Mar3
AppleFeb_2020Feb2
MangoApr_2020Apr4
GuavaFeb_2020Feb2
GuavaJan_2020Jan1
MangoMar_2020Mar3

 

And I want to sort it basis name first and then Month Order as below result:

 

NamePeriodMonthMonth_Order
AppleFeb_2020Feb2
AppleMar_2020Mar3
AppleApr_2020Apr4
GuavaJan_2020Jan1
GuavaFeb_2020Feb2
MangoJan_2020Jan1
MangoFeb_2020Feb2
MangoMar_2020Mar3
MangoApr_2020Apr4
OrangeJan_2020Jan1
PeachFeb_2020Feb2
12 REPLIES 12
avo
7 - Meteor

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

 

 

 

 

SrinivasanSugumaran
8 - Asteroid

HI  ,

 

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

NameMonthSalary
ajul1
bdec2
ajan3
bsep4

 

expected output:

 

 

 

 

NameMonthSalary
bdec2
bsep4
ajul1
ajan3
BrandonB
Alteryx
Alteryx

Your sorting issue is likely because "Month" is trying to be sorted alphabetical. You can derive an actual date value from month and use that to sort as a proxy for your current month column to achieve the desired sort order. 

 

date parse 1.png

 

 

date parse 2.png

Labels