Skip to main content Skip to complementary content

Defining a column analysis

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.

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 – please let us know!

Leave your feedback here