Question

Create error report containing failed tester attributes

C
Badge

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
Rank
Userlevel 4
Badge +30

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
Badge

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

Reply


Community Stats

28,731
Posts
109,530
Replies
36,565
Members
Terms & ConditionsCookie 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.