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.501956802668840.44811287961.5523915.51182.5202.515064819390.8131257.210323712520277012115.6190654.4117.5437.50

How to clean up final data

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

Workflow

Accepted answers

Thableaus

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,

All comments

Thableaus

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703