Showing analysis results - 8.0

Talend Data Management Platform Getting Started Guide
Version
8.0
Language
English
Operating system
Data Management Platform
Product
Talend Data Management Platform
Module
Talend Administration Center
Talend Installer
Talend Runtime
Talend Studio
Content
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
Last publication date
2024-04-15
Once you finalize creating the column analysis and setting the indicators and patterns, you can execute it and display analysis results in tables and charts.

Before you begin

  • You have opened the Profiling perspective in Talend Studio.

  • You have created a column analysis. For further information, see Identifying anomalies in data.

Procedure

  1. In the Analysis Parameters, select java from the Execution engine list to run the analysis with the Java engine.
  2. In the analysis editor, press F6 to execute the analysis or click the Run button.

    The editor switches to the Analysis Results view. The analysis results show the generated charts for the analyzed columns accompanied with tables that detail the statistic and pattern matching results.

    The results for the Email column look as the following:

    The results for the Phone column look as the following:

Results

The result sets for the Email and Phone columns give the count of the records that match and those that do not match the standard email pattern and the standard US phone numbers respectively. The results also give the blank and duplicate counts. This shows that the data is not very consistent and that it needs to be corrected.