Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sorting Columns

jlfromm
8 - Asteroid

I have the following information in the column headers 

 

jlfromm_0-1675265167216.png

I would like the order to go 

F1 then everything else in Alpha order

 

 

3 REPLIES 3
FinnCharlton
13 - Pulsar

Hi @jlfromm , here is one way using the Field Sort CReW macro, download it here: http://www.chaosreignswithin.com/p/macros.html

FinnCharlton_2-1675265810312.png

 

 

 

FinnCharlton
13 - Pulsar

@jlfromm , this is a way you can do it without the macro:

FinnCharlton_0-1675266086873.png

 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

@jlfromm One way! 

Before:

BS_THE_ANALYST_0-1675266382730.png

 

After:

BS_THE_ANALYST_1-1675266394534.png

Worfklow:

BS_THE_ANALYST_2-1675266413640.png

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors