Skip to main content
Question

separately missing, null and empty values

  • June 6, 2023
  • 1 reply
  • 16 views

Hi, 

 

I want to separately identify missing, null and empty values in a data array.

I tried with the TestFilter, the sorting does not seem to be done correctly.

Because, my file contains null and missing values but here all data exits in one place.

 

Do you have a solution ?

Thanking you in advance

 

 

image

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+49

The TestFilter should work for this, but to be certain:

 

Inspect the data and check how FME sees the values. If they are indeed missing, null or empty then doublecheck how you've set up the TestFilter.

It would help if you could share screenshots of both the data and the TestFilter parameters


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