Skip to main content Skip to complementary content
Announcements

Defining a match analysis from the Analysis folder

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.
    Information noteImportant:

    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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here