Skip to main content
Solved

Want to differentiate whether a file contains all null values in particular column or only null values in few rows.

  • February 23, 2023
  • 2 replies
  • 39 views
G

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.

Best answer by markatsafe

@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 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • Best Answer
  • February 23, 2023

@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 

G
  • gowripriya2k
  • Author
  • 4 replies
  • February 25, 2023

@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!​

Community Stats

32,065
Posts
121,735
Replies
39,691
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.