Issue converting number with comma in Alteryx Cloud"

[GabrielFernandes]

Hi community!

I'm working with a Brazilian client and in Brazil, they use commas (",") instead of dots (".") for numbers. I have a dataset already treated as text where my number is "2102,9700001", but I'd like to convert it to a number and save it with a comma (","). In the regular Alteryx Designer, it's possible to do this by changing the currency type. How can I do this in Alteryx Cloud? I've already tried 3 different ways and nothing worked...

 

Original

[smuravskyi]

Hey Gabriel,

I suggest using the "Use Commas as Decimal Separators (String/Numeric Conversions Only)" option in the Select Tool. It should handle this case.

[GabrielFernandes]

@smuravskyi 

Thanks for the help!

I did exactly that but it was left with "." or instead of "," even in the photo you attached it looked like this

I saved the file in Excel and it was left with "."