Skip to main content
  • EN

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

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

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.