Skip to main content
Question

Create error report containing failed tester attributes

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.

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • 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

jneujens
Forum|alt.badge.img
  • jneujens
  • June 22, 2018

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

Reply


Helpful Members This Week

Community Stats

31,284
Posts
118,657
Replies
38,872
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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