Replace null values

[sallyjeon124]

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?

[ChrisTX]

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

[ydmuley · Accepted solution]

@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.

[sallyjeon124]

@ydmuley

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!

[ydmuley]

The method will remain same @sallyjeon124 

Convert the double column to VW String and then use the formula.