Replacing Null w/ Text in a string field

reynae3

Hey there, 

I am looking to replace Nulls with an "N" in a string field where all records are either flagged "Y" or are null.  

There are about 4 fields I need to transform in this same way. 

I realize this topic has come up before but for some reason, the configuration of the multi-field formula tool always gives me an error. 

Appreciate any help on this (does not have to include the multi-formula tool). 

CharlieS

Hello @reynae3,

You are correct in that the Multi-field Formula tools would be useful in this situation. Here's the formula that can be used in that tool:

IF isnull([_CurrentField_]) THEN "N"
ELSE [_CurrentField_] ENDIF

Let me know if you have any other questions.