Defining a column analysis - 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
You want to create a column analysis from the Profiling perspective of the Studio to examine the Email and Phone columns in a MySQL databases and collect statistics on them. The analysis runs on several columns but each column is analyzed separately and independently.
  • You have opened the Profiling perspective in the Studio.

  1. In the DQ Repository tree view, right-click Analyses and select New Analysis.

    The [Create New Analysis] wizard opens.

  2. Start typing Basic column analysis in the search field, select Basic Column Analysis from the list and click Next.
  3. In the Name field, enter a name for the analysis.

    The Name field is mandatory. Do not use spaces or special characters in the analysis name.

  4. Set a purpose and a description for the analysis, and click Finish to open the analysis editor.

    The Purpose and Description fields are not mandatory, but you are advised to fill in this information which is displayed in Detail View when you select the analysis.

The new analysis is listed under the Analysis folder in the DQ Repository tree view.