How to clean up final data

[AustinRiggs94]

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

393130	72017.5	321112.5	980.5	335.5	0
1956802	668840.4481	1287961.552	3915.5	1182.5	202.5
150648	19390.8	131257.2	103	237	125
202770	12115.6	190654.4	117.5	437.5	0

[Thableaus · Accepted solution]

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,

[AustinRiggs94]

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

[Thableaus]

@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,