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.
You will only be able to store N/A in a field if the data type is String
@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.
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!
The method will remain same @sallyjeon124
Convert the double column to VW String and then use the formula.