This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Modelbuilder null/missing/empty variable handling

I have a large database of customer demands with additional information (address, name etc) that is preprocessed in FME before it is imported into a model using modelbuilder. Some customers are missing some data (address/name etc.), how should I preprocess this data to import a valid database into the model using modelbuilder? I have the option to treat the missing data in 3 ways:

- Empty (attribute exists as an empty string)

- Null (attribute exists with value null)

- Missing (attribute does not exist)

Currently the missing attributes are stored as null, is modelbuilder able to handle null values?