"Replace missing values by empty string?"

vwegert

Hello,

I need to replace missing values in some text fields of an example set with an empty string (mostly because some of the subsequent formulae won't be executed otherwise). The Replace Missing Values operator should be the obvious solution, but I can't use "default zero" on text attributes, and "default value" forces me to set a non-empty replenishment value. I could use the latter to insert a dummy value that is not part of the actual data set, then use a second operator to replace the dummy value. Unfortunately, I can't use the "Replace" operator on text attributes, so I would have to use Generate Attributes and a lot of similar formulae. Is there an easier way for this?

Thanks
  Volker Wegert

MartinLiebig

Hi Volker,

could you maybe post example data? I am a bit unsure what you really want to do.

~Martin