- In the Profiling perspective, click the Analysis Results tab at the bottom of the editor.
In the Pattern
Matching results of the email column, right-click the chart bar
or the numerical results and select Generate Job.
The Integration perspective opens showing the generated Job.
This Job uses the Extract Transform Load process to write in two separate output files the valid/invalid email rows that match/do not match the pattern.
- Save the Job and press F6 to execute it.
The valid and invalid rows of the email column are written in the defined output files.
You can replace the output files with different Talend components and recuperate the valid/invalid email rows and write them in databases for example.
For further information on using the Profiling perspective to identify and remove corrupt, incomplete or inaccurate data, see the Data Cleansing chapter in Talend Studio User Guide at https://help.talend.com.
For further information on using the Profiling Profiling perspective to identify and remove corrupt, incomplete or inaccurate data, see the Data Cleansing chapter in Talend Studio User Guide.