convert specific cell to double from v_string

[kauser]

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 

[Qiu · Accepted solution]

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

[caltang · Accepted solution]

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.