SOLVED
Replace null values
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sallyjeon124
7 - Meteor
‎04-02-2020
08:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have two different data type - date and double
If the value is null, I want to replace null with N/A.
But since N/A is string, I keep giving me error message.
Can anyone help?
Solved! Go to Solution.
4 REPLIES 4
16 - Nebula
‎04-02-2020
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You will only be able to store N/A in a field if the data type is String
12 - Quasar
‎04-02-2020
09:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sallyjeon124 You can convert the date to V_WString and Even the numeric column to V_WString to achieve this.
I have attached the workflow for your reference. Hope this helps.
Regards,
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
‎04-07-2020
11:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your workflow. It works for the date.
I am also looking for a way I can convert 0 (in double type column) into N/A.
Do you have any idea on this?
Thanks!
12 - Quasar
‎04-07-2020
09:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The method will remain same @sallyjeon124
Convert the double column to VW String and then use the formula.
Regards,
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)