Help transforming salary ranges in descending order

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,

GenderPayGap_Alteryx.xlsx

Help

Accepted answers

grazitti_sapna

@arundaka03, give this a try.

Thanks!

arundaka03_workflow.yxmd

All comments

IraWatt

Hey @arundaka03,

Here is one way to do this:

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

Workflow.yxmd

MarqueeCrew

@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

grazitti_sapna

@arundaka03, give this a try.

Thanks!

arundaka03_workflow.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703