Fieldtype Number with Comma as decimal seperator
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear All,
In my company we use the Comma as decimal seperator. Therefore, I would like to achieve the following in my output excel:
output excel:
All fields which include numbers should be field type 'Number' in excel and the decimal seperator should be a Comma.
When I am changing the field type in alteryx through Select tool or formula (ISNUMBER) then the amounts dissapear in all the fields.
I hope you can help me.
Solved! Go to Solution.
- Labels:
- Output
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you try going to Options > User Settings > Edit User Settings... > Localization [tab] and then selecting the Decimal Symbol to be a comma? Think this should work.
Thanks,
Philip
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jaapkluck
As @PhilipMannering pointed out, you can change the decimal separator in the User Settings.
Changing the settings is only for your visualization.
With what you mentioned last regarding changing it to a numeric format and the data disappearing, you need to pay attention to see if Alteryx is understanding it as a string, then you need to before changing the datatype, use the Formula Tool to do a Replace Function to assign the correct separator instead of the one over there, to then change it to a proper format.
Pedro.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, I see. Thanks @pedrodrfaria
You could also try using the function
tonumber([Field1], 1, 1, ',')
The fourth argument specifies the decimal separating character.
