FME Desktop 2022: How to filter all records based on the “null” value of particular field?
In the screenshot, I couldn’t figure out how to filter all records that have “null” values in the “ump_layers”
Solved
FME Desktop 2022: How to filter all records based on the “null” value of particular field?
+5Best answer by david_r
In the Tester operator column, replace "=" with "Attribute is null" from the drop-down list.
Using equals will only test for empty strings, not null values.
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.
- Best Answer
In the Tester operator column, replace "=" with "Attribute is null" from the drop-down list.
Using equals will only test for empty strings, not null values.
+5Thank you for the help
+59- Safer
Although you already have a perfectly good answer, I covered this subject in my Question-of-the-Week video. I made it more of a general introduction to nulls in FME, so you might find other parts that are of interest to you, such as how to set a null value and how different formats treat them.
+5Thank you for sharing the video. Very useful