community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to clean up final data

Asteroid

Hey Everyone,

 

Quick question, is there a way to "clean" up the data within alteryx. i.e., add $ or commas, take out any decimals etc., Data sample is below, thanks.

 

 

$$                    $$                        $$           Take away decimal   Take away decimal

39313072017.5321112.5980.5335.50
1956802668840.44811287961.5523915.51182.5202.5
15064819390.8131257.2103237125
20277012115.6190654.4117.5437.50
Alteryx Certified Partner
Alteryx Certified Partner

Hi @AustinRiggs94 

 

If your are looking for a currency conversion, and your field is a Double Type one, you may use this formula.

 

'$'+ToString([original_value], 2, 1)

 

There are many ways yo clean up data with Alteryx, you need to be more precise about what you have now, and what you want to achieve.

 

Cheers,

Asteroid

@Thableaus Thanks! i was hoping to not use a formula and hopefully a tool has been developed but oh well. Thanks again!

Alteryx Certified Partner
Alteryx Certified Partner

@AustinRiggs94 

 

There are some macros in the Gallery about this subject.

One of them is this one, developed by @JoeM  https://gallery.alteryx.com/#!app/Currency-Formatter/58e3bb54f499c713d41b3706

 

Cheers,

 

Labels