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”
Best answer by david_r
View original
FME Desktop 2022: How to filter all records based on the “null” value of particular field?
+5
Userlevel 4
- 8170 replies
-
4 March 2022
- 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.
+5
Thank you for the help
Userlevel 4
+25
- Safer
- 2392 replies
-
7 March 2022
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.
+5
Thank you for sharing the video. Very useful
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.