Defining a column analysis - 7.3

Talend Real-Time Big Data Platform Getting Started Guide
Version
7.3
Language
English
Operating system
Real-Time Big Data Platform
Product
Talend Real-Time Big Data Platform
Module
Talend Administration Center
Talend DQ Portal
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
2023-07-24
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.

Before you begin

  • You have opened the Profiling perspective in the Studio.

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.