Skip to main content
  • EN

Hello all,

I had one file which contains some null values and some state values. So in that case I am using the tester to filter null and non null values .but another file contains all the null values in the same column.so in the both cases we are getting the output in failed port as both files contains​ some null values. So how to differentiate whether a particular file contains all null values in the column or only few null values. So that if file contains all null values then we can send the error message.

@gowripriya2k​ You can use StatisticsCalculator in more recent versions of FME (2022). Compare Total Count to Value Count. For strings, set the 'Method' to String. For columns that have all ,null> values, the Value Count = 0

image 

@gowripriya2k​ You can use StatisticsCalculator in more recent versions of FME (2022). Compare Total Count to Value Count. For strings, set the 'Method' to String. For columns that have all ,null> values, the Value Count = 0

image 

Thankyou, it worked for me!​

Reply


Community Stats

30,126
Posts
114,351
Replies
37,758
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.