In a preparation script, use the processor Formula with the coalesce function :
The function can work with multiple columns: coalesce(null, null, "string") -> "string"
Matt