# How to report validation failures?

**URL:** <https://community.easymorph.com/t/how-to-report-validation-failures/1876>\
**Category:** General Q&A\
**Created:** [May 28, 2020, 8:26am UTC](https://community.easymorph.com/t/how-to-report-validation-failures/1876 "2020-05-28T08:26:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DoStep](https://community.easymorph.com/letter_avatar_proxy/v4/letter/d/f9ae1b/32.png) [@DoStep](https://community.easymorph.com/u/DoStep)\
**Post date:** [May 28, 2020, 8:26am UTC](https://community.easymorph.com/t/how-to-report-validation-failures/1876/1 "2020-05-28T08:26:19Z")

</div>

Hi

I'd like to run a number of validations over the imported data and be able to 'report' on any exceptions.  
Ideally I would like to append each record that fails validation to a separate table, populating a column that indicates which validation test it failed.

These would then be reviewed by the data owners.

How would I achieve this in EasyMorph?

Apologies if this is a noob question, I'm new to EasyMorph and haven't yet found an answer.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [May 28, 2020, 4:55pm UTC](https://community.easymorph.com/t/how-to-report-validation-failures/1876/2 "2020-05-28T16:55:09Z")

</div>

Hi @DoStep and welcome to the community!

Here is a simplified example project:

[ValidateRows.morph](https://community.easymorph.com/uploads/short-url/x8xqV8QqQbnnI467dxWdhLbXnFr.morph) (6.0 KB)

Its workflow is as follows:

- Use the "[Rule](http://help.easymorph.com/doku.php?id=transformations:rule)" action to create a column with validation errors. Note that only the first found error will be added to that column.
- Use the "Derive table" action and filters to separate valid and invalid rows
- Use the "Derive table" action in the "On condition" mode to handle invalid rows (this example  
stores invalid rows in a CSV file and sends it via email).

Please refer to the following tutorial for more details on the "On condition" mode:

> **[Conditional workflows](https://easymorph.com/learn/conditional-workflows.html)**
>
> Illustrated tutorial on data preparation and transformation with EasyMorph. Covers data preparation basics, advanced topics, and workflow automation.

 ![image](https://community.easymorph.com/uploads/default/original/2X/8/89b1c02140d4d3fef97b95d211b35cd569f4e335.png)