Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace null values

sallyjeon124
7 - Meteor

 

 

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?

 

output.JPG

4 REPLIES 4
ChrisTX
15 - Aurora

You will only be able to store N/A in a field if the data type is String

ydmuley
12 - Quasar
12 - Quasar

@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
sallyjeon124
7 - Meteor

 

@ydmuley

 

 

ydmuley
12 - Quasar
12 - Quasar

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
Labels