convert specific cell to double from v_string

Question

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.0025.5746%34.7435%2543535.98565466.89

Expected view -

$127,284,378.0025.5746%34.7435%$2,543,535.98$565,466.89

Thank you

kauser

Qiu · Accepted Answer

@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-Data/m-p/1258174#M313603

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 Answer

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-Alphanumeric-Columns/m-p/1208050#M299818

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