Showing analysis results - 7.0

Talend Data Fabric Getting Started Guide

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
Talend Administration Center
Talend DQ Portal
Talend Installer
Talend Runtime
Talend Studio
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.
  • You have opened the Profiling perspective in the Studio.

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

  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:

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.