Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
16 - Nebula

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
16 - Nebula

@arundaka03, give this a try.

 

grazitti_sapna_0-1659936436466.png

 

Thanks!

Sapna Gupta
Labels