Skip to main content
Solved

Attribute Validation - Not Null

  • March 8, 2025
  • 3 replies
  • 53 views
iamprem
Contributor
Forum|alt.badge.img+5

I am performing data validation of a excel source data.

I have configured multiple validations in Attribute validator.

Issue:
FME validates the not null validation and all other validations given, but what I require is if any of the attribute is null, I don't want to do any other validations.

How do I perform these in FME?

Best answer by crutledge

Hey ​@iamprem If I understand correctly this is what I meant. Does that help? I hope I understand correctly.

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

3 replies

crutledge
Influencer
Forum|alt.badge.img+43
  • crutledgeInfluencer
  • Influencer
  • March 8, 2025

Hi There, I would maybe put a tester or test filter before that and put the null evaluation statement there. Then direct the fails one way and the passes another. Hope that helps!

c.

At your rest service ^B
iamprem
iamprem
Contributor
Forum|alt.badge.img+5
  • iampremContributor
  • Author
  • Contributor
  • March 8, 2025

Hi ​@crutledge 

I am generating a validation report, I want null values to be validated and included in report, but if the value for a attribute is null, I don't want other validations to be performed for the same attribute again.

How do I handle this scenario?

crutledge
crutledge
Influencer
Forum|alt.badge.img+43
  • crutledgeInfluencer
  • Influencer
  • Best Answer
  • March 8, 2025

Hey ​@iamprem If I understand correctly this is what I meant. Does that help? I hope I understand correctly.

At your rest service ^B
iamprem

Community Stats

32,132
Posts
121,974
Replies
39,787
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.