Defining a match analysis from the Analysis folder

Procedure

In the DQ repository tree view, expand Data Profiling and right-click Analyses > New analysis.

The Create new analysis wizard opens.
Select Table > Match analysis and click Create.
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.
From the Connection menu, select the connection and click Next.
The columns you select should be in the same table. Currently, the match analysis does not work on columns in different tables.

A data preview is displayed.

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.

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