"Replace missing values by empty string?"

vwegert
vwegert New Altair Community Member
edited November 2024 in Community Q&A
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

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi Volker,

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

    ~Martin
  • vwegert
    vwegert New Altair Community Member
    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.

    Volker