"Replace missing values by empty string?"

vwegert
New Altair Community Member
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
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
Tagged:
0
Answers
-
Hi Volker,
could you maybe post example data? I am a bit unsure what you really want to do.
~Martin0 -
Hi Martin,
I'm simply importing CSV files that contain some empty "cells" and need to replace the "missing" values in some fields with an empty string.
Volker0