Data Cleansing

[keithr197]

Hi All

I have a data set where i want to replace all fields that has a "Not Applicable" value to "Blank", so something similar to the imputation tool (but that is only for numeric values). I tried using the data cleanse tool with no luck.

Thanks for the assistance 

[Emil_Kos · Accepted solution]

Hi @keithr197,

This should work for you. I have used multi-row formula with a replace function:

Replace([_CurrentField_], 'Not Applicable', null())

Input:

Output: