Question

Write invalid records to a CSV writer


Badge

Hi I would like to output only the rejected records on each transformer output to a CSV file, and also write total count of invalid records.

Any suggestion what's the best way to achieve this?


2 replies

Userlevel 2
Badge +16

Most important: Change the "Rejected Feature Handling" parameter to continue and not terminate the translation:

Then attach the CSV writer feature types to all Rejected ports you want recorded.

Badge +11

If you are looking to get the sum of all features rejected you can use the Total Count Attribute of the StatisticCalculator and pass that information to a separate CSV feature type.

Reply