Defining a column analysis - 6.5

Talend Open Studio for Data Quality Getting Started Guide

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Open Studio for Data Quality
task
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
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.

Procedure

  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.

Results

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