In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Sorting data by rows

limats
7 - Meteor

Hi there,

 

Apologies for the basic question, but how do you sort and order data by field name, so not by not ascending/chronological order.

 

E.g. I have:

 

 

Column One Column Two
AC
AR
AP
WC
WR
WP
GC
GR
GP
MC
MR
MP
TC
TR
TP
IC
IR
IP

 

I want:

 

WR
WC
WP
AR
AC
AP
IR
IC
IP
GR
GC
GP
MR
MC
MP
TR
TC
TP

 

Thanks in advance

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Hi @limats 

 

If I understand correctly, you want to create a custom sort order. This is how I would do it.

 

DavidP_0-1600253026020.png

 

Amarendra
10 - Fireball

@limats You can add weights to your custom field and then use a tile tool to sort. See attached

limats
7 - Meteor

Yes this works - thank you!

Labels
Top Solution Authors