Alteryx Designer Desktop Discussions

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

convert specific cell to double from v_string

kauser
8 - Asteroid

Hello, 

is there any way to convert specific cell to double from v-string. i have to keep both v-string and double i mean both % and $ on output column 

 

current view - 

127284378.00
25.5746%
34.7435%
2543535.98
565466.89

 

Expected view - 

$127,284,378.00
25.5746%
34.7435%
$2,543,535.98
$565,466.89

 

Thank you 

 

kauser 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@kauser 
I recently learned that there is function "ToString" allows us to add the Thousand Seperator.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/adding-comma-and-bracket-in-Da...

So we can do something like this.

Just to be clear, we can not have 2 different Alteryx Data types in one single field.

0901-kauser.png

caltang
17 - Castor
17 - Castor

If you want to export them and have each cell with different data types, @gawa has done something here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Converting-Numbers-In-Alphanum...

 

You can first use @Qiu 's method to standardize your workflow then when you output, you can apply what Gawa has done accordingly.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels