We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Cleaning up amounts expressed with abbreviations

NMorgan
7 - Meteor

Hello, I'm an Alteryx beginner and I'm looking for some help in cleaning up some sample data which has amounts expressed with abbreviations such as K for Thousands and M for Millions.

 

As an example I have data that looks as per below:

 

$102.5M

$32M

$220K

$2M

 

I'd like this to show as a plain number so the first would be 102,500,000 etc. How do I go about doing this in Alteryx?

3 REPLIES 3
ShankerV
17 - Castor

Hi @NMorgan 

 

One way of doing this.

 

ShankerV_0-1681989261190.png

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @NMorgan 

 

Step 1: 

ShankerV_0-1681989290971.png

 

Step 2: 

 

ShankerV_1-1681989308750.png

([0-9.]+)(\u)

ShankerV_2-1681989318169.png

 

Step 3:

 

ShankerV_3-1681989345807.png

 

IF [RegExOut2]="M"
THEN [RegExOut1]*1000000
ELSE [RegExOut1]*1000
ENDIF

 

ShankerV_4-1681989355205.png

 

 

Many thanks

Shanker V

binuacs
20 - Arcturus

@NMorgan Another method

binuacs_0-1681999222144.png

 

Labels