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