We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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