Convert string to number (with comma) via select tool

[PangHC]

i thought i was an old issue,  but i search few time and can not find any.

can we direct convert string to number without remove ","?

1,000.00 from string  convert directly to 1,000.00 number.

it is annoying to add a formula tool to remove the ","

[CristonS]

hi @PangHC thanks for the feedback! Unfortunately, numeric types cannot contain string characters. If you want to physically see the comma separator in the results grid for the numeric field, you can use the ToNumber() function with the new toggle, but it won't actually have the comma separator in the data field itself.

We'll be sure to pass this along to our product management team as soon as the necessary criteria are met.

[PangHC]

@CristonS

if possible i happy to use select tool, because it is the purpose of select tool. and it easier when i have many field

it should be a quick fix item. either built in the formula in the select tool to exclude any "," when any number conversion.

[Matthew]

i just ran into this issue today. i needed to use a formula tool with the "tonumber()" function before the select tool because alteryx wouldn't recognise the number field if the commas were there.. the select tool should be able to recognise a number that contains comma separators