Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Help transforming salary ranges in descending order

arundaka03
7 - Meteor

Hi everyone. 

 

I need to transform a list of salary ranges so they appear in descending order and have 'Prefer not to say' at the bottom. I have attached the Excel of the table and it is column 'My current salary is...' that needs transforming. 

 

Is there a way I can transform the column so they appear in the following order:

 

My current salary is....
Over £200,000
£180000 - 199,999
£160,000 - 179,999
£140,000 - 159,999
£120,000 - 139,999
£100,000 - 119,999
Under £20000
Prefer not to answer

 

Thanks in advance,

KA

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @arundaka03,

Here is one way to do this:

IraWatt_0-1659885475685.png

My approach was to get the salary as a number (not text) then sort by that. I got the number using regex then use a formula to make it a number.

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@arundaka03 ,

 

i would create a SORT field that is numeric based upon the values.  Another approach is to define the values with a leading number.  Then at the end of your process use a substring function to skip the number and update the field. 

cheers,

 

 mark 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
grazitti_sapna
17 - Castor

@arundaka03, give this a try.

 

grazitti_sapna_0-1659936436466.png

 

Thanks!

Sapna Gupta
Labels