Skip to main content
Question

Write invalid records to a CSV writer

  • July 28, 2017
  • 2 replies
  • 11 views

Forum|alt.badge.img

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?

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

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • July 28, 2017

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.


steveatsafe
Safer
Forum|alt.badge.img+13

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.