Hi Experts,
Have a large datasets,below is one of the example which i need to convert the numeric value as an output. The data type is mentioned as "Decimal" on select tool.
1000.00 to be converted to 1.000,00
100000.00 to be converted to 100.000,00
Please advice.
Thanks,
Guru
Hello @Inactive User !
Here in Brazil we use comma as decimal separators, try to convert these fields into a string field and then just replace the "." for ","
Hello @dougperez
If i change the sting - it will only replaces the decimal as comma, but however is it will not change the numeric.
Example - currently alteryx is reading as only 1000.00 i.e.1,000.00, but i need to make it 1.000,00.
Thanks,
Guru
Hi @Inactive User ,
Maybe you can check your user settings? There you can define what's your thousand separator is and what's your decimal separator
Hi @AngelosPachis - Am looking for simple formula to process the data sets. Is there any way ? please advice.
@Inactive User If you change to 1.000,00 you should change the datatype to string
Try this formula:
ToString([Field1], 2, 1,",")
But you will need to create a string field to do this
Hi @dougperez - I tried this logic, it will only help me to perform only on the decimal part.
Here i need to change a large data set involving multiple values involving thousands, millions as amounts.
Example - 10234.13 needs to change 10.234,13
10012345.19 needs to change to 10.012.345,19
can you please help me ?
Thanks,
Guru