Choosing 'No Substitution' for Substitute Missing, Null and Empty by attribute can result in null or missing values in your dataset.

Prepare for the FME Certified Professional Exam. Study with flashcards and multiple-choice questions; each question includes hints and explanations. Ensure your success!

Multiple Choice

Choosing 'No Substitution' for Substitute Missing, Null and Empty by attribute can result in null or missing values in your dataset.

Explanation:
Choosing No Substitution means the operation does not fill in missing, null, or empty values. Features that have a missing attribute will carry that missing value forward, so the output dataset can include nulls or blanks. This is why selecting No Substitution can produce null or missing values in the result. If you want to prevent that, substitute with a value from another attribute or with a default constant. Keep in mind some formats treat nulls differently, but the basic idea is that not substituting preserves the missing state, which can show up as nulls in the output.

Choosing No Substitution means the operation does not fill in missing, null, or empty values. Features that have a missing attribute will carry that missing value forward, so the output dataset can include nulls or blanks. This is why selecting No Substitution can produce null or missing values in the result. If you want to prevent that, substitute with a value from another attribute or with a default constant. Keep in mind some formats treat nulls differently, but the basic idea is that not substituting preserves the missing state, which can show up as nulls in the output.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy