Cleansing data - 6.4

Talend Data Management Platform Studio User Guide

Talend Data Management Platform
Data Quality and Preparation
Design and Development
Talend Studio

After profiling customer data and identifying its problems, some actions should be taken on data to cleans it. You may start by generating two Talend Jobs: one to remove duplicates from the email column and the other to remove the values that do not match the email pattern.

This will help you seeing what to resolve and then you can decide what tool to use to intervene and resolve these address issues.