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