How can I include null values in the list of acceptable values (Validation Rule = In)?
Also, if an attribute is null, how does that impact the Type (Validation Rule = Type)?
Question
Null In Attribute Validator List
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
Null is not a value. There is no operand. (no pointer etc.)
Null is not represented by a type.
Unless..
Type: Null is a quadruped, chimeric Pokémon with traits from a variety of creatures.
Or more seriously
an implementation-defined null pointer constant, cast to void.
etc.
+26- Contributor
I would add a NullAttributeMapper before the AttributeValidator and map the Null value to an actual value (e.g. "Unknown" for strings, -999 for numeric). Then you can add that value to the list of acceptable values in the AttributeValidator.
+29- Enthusiast
I would add a NullAttributeMapper before the AttributeValidator and map the Null value to an actual value (e.g. "Unknown" for strings, -999 for numeric). Then you can add that value to the list of acceptable values in the AttributeValidator.
+26- Contributor
@erik_jan Great idea... The other idea that I had was to use a tester, but for now I guess I'll give your idea a try :)
- Contributor
Due to the lack of a discreet "Is Null" evaluator, when looking to pass (as opposed to fail) Null values through the AttributeValidator, use the "Not Null" Rule/Evaluator and invert the output ports - connect Failed as a Pass and Passed as a Fail.
The logic here is that you are looking for the opposite of "Not Null" which is the failed subset of "Not Null", it's the equivalent of "Is Null" with the output channels reversed/transposed.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.