This scenario applies only to a subscription-based Talend Platform solution or Talend Data Fabric.

This scenario is a two-component Job created in
Talend Studio
.
In this Job, tMySQLInvalidRows reads the email
addresses for people from a specific country from a MySQL database table, filters data
using a WHERE clause to narrow down the validation process, checks the email values
against the given
Talend Studio
email pattern and
finally extracts filtered data including the invalid rows and displays them on the
console.

Below is the database table used in this example, some customers are from the USA and
others are from Canada. The Email column contains some invalid
addresses. The tMySQLInvalidRows component filters data
in the Email column to read only the emails for the customers from
the USA, and then validates these email addresses against the
EmailAddress pattern.

In this scenario, we have already stored the schemas of the input table in the
Repository. For more information about storing schema metadata in the Repository tree view, see
Talend Studio User
Guide.