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?