Alteryx Desktop: multi-field tool is changing the decimals
- 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
Hi,
Could you please advise how to fix the following issue. I am using multi-field formula to replace nulls to 0 and multi-field formula tool ( I also tried cleansing tool, the same behaviour) and after applying this tool decimal values are changed, please see below:
Thank you in advance!
Best regards,
Oksana
- Labels:
- Output
- Reporting
- Settings
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you using a fixed decimal datatype? If so, Alteryx will be forced to show at this level. Unless you're needing this level of detail, you could change it to a double? If you're wanting to replace nulls with 0, could you not just use the data cleanse tool? Does that have the same effect?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could also do something like this. This maintains just being 0 if you then change it back to a number (FixedDecimal included) with a select tool afterwards:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! Thank you for your reply. Yes, I need fixed decimal datatype. Data cleanse tool has the same behaviour, I initially used it.
Best regards,
Oksana
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, as a workaround it may be used, but I would rather not apply it, as I have lots of columns, which this logic would have need to be applied for, it would probably influence the performance.
Thank you a lot for your suggestions.
Best regards,
Oksana
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You wouldn't need a formula for each, you could just use another multi-field (then select after to change back to FixedDecimal). If it's not a viable option then no problem but can't think of any other options off the top of my head!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Using a select tool just before a data cleanse tool, modify the Sales Value field type tp Fixed Decimal, size 19.10.
Result.
SALES VALUE
2524.5779000000
0.0000000000