Skip to main content
Question

Create error report containing failed tester attributes


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+44
  • 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
  • June 22, 2018

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


Reply


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