Defining a match analysis from the Analysis folder - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-22
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Procedure

  1. In the DQ Repository tree view, expand Data Profiling.
  2. Right-click the Analysis folder and select New Analysis.
    Screenshot of the DQ Repository tree view.
    The Create New Analysis wizard opens.
  3. Start typing match in the filter field, select Match Analysis and click Next to open a wizard.
    Screenshot of the Create New Analysis wizard.
  4. Set the analysis name and metadata and then click Next.
    Important:

    Do not use the following special characters in the item names: ~ ! ` # ^ * & \\ / ? : ; \ , . ( ) ¥ ' " « » < >

    These characters are all replaced with "_" in the file system and you may end up creating duplicate items.

    Screenshot of the New Analysis dialog box where the analysis name is matching_names, the description is analyzing duplicates in the name columns, and the status is development,
  5. Expand DB connections or FileDelimited connections depending on if the columns you want to match are in a database or a delimited file.
    Screenshot of the New Analysis dialog box.
  6. Browse to the columns you want to match, select them and then click Finish.
    The columns you select should be in the same table. Currently, the match analysis does not work on columns in different tables.
    The match analysis editor opens listing the selected columns.
    Screenshot of the Match Analysis editor.
    You can also define a match analysis starting from the table or columns you want to match. For further information, see Defining a match analysis from the Metadata folder.
  7. Modify the parameters in the match analysis editor according to your needs.
    For further information, see Configuring the match analysis.