Skip to main content
Question

Create error report containing failed tester attributes

  • June 19, 2018
  • 2 replies
  • 10 views
C
Forum|alt.badge.img

Hi,

I am carrying out data quality tests and I would like the results of failed tests in an excel doc. I would normally use the AttributeValidator and the _fme_validation_message but I need to use testers.

An example of one test: if the 'type' = individual then the 'industry sector' should be null. So in the table below, I would want to see the last line in an error report

TypeIndustry sectorindividualcompanyagriculturecompanyconstructionindividualretail

Any suggestions welcome.

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

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • June 22, 2018

Hi @cam

I created a simple Workspace with the Excel file like Source.

The transformer Tester was used to filter the Individual value:

The transformer AttributeCreator was used to set Null value for Industry sector when the Type = individual:

Results in FME Data Inspector:

Thanks,

Danilo

Partner Solutial Brazil - www.solutial.com.br
jneujens
Forum|alt.badge.img
  • jneujens
  • 189 replies
  • June 22, 2018

Can't you just connect an excel writer to all the failed ports of the testers?

Community Stats

32,085
Posts
121,845
Replies
39,727
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.