Defining a match analysis from the Analysis folder - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

Procedure

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

    Avoid using special characters in the item names including:

    "~", "!", "`", "#", "^", "&", "*", "\\", "/", "?", ":", ";", "\"", ".", "(", ")", "'", "¥", "'", """, "«", "»", "<", ">".

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

  5. Expand DB connections or FileDelimited connections depending on if the columns you want to match are in a database or a delimited file.
  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.
    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.