Skip to main content
Solved

FME Desktop 2022: How to filter all records based on the “null” value of particular field?


jamal
Forum|alt.badge.img+5

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”

 

 

 

Clip_155 

Best 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.

View original
Did this help you find an answer to your question?

4 replies

david_r
Celebrity
  • Best Answer
  • March 4, 2022

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.


jamal
Forum|alt.badge.img+5
  • Author
  • March 4, 2022

Thank you for the help

 

Clip_156


mark2atsafe
Safer
Forum|alt.badge.img+44

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.

 

See https://www.youtube.com/watch?v=oPkjLqq0hzI&t=226s


jamal
Forum|alt.badge.img+5
  • Author
  • March 8, 2022

Thank you for sharing the video. Very useful

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings