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.
In the DQ Repository tree view,
right-click Analyses and select New Analysis.
The Create New Analysis wizard opens.
- Start typing Basic column analysis in the search field, select Basic Column Analysis from the list and click Next.
In the Name field, enter a name for
The Name field is mandatory. Do not use spaces or special characters in the analysis name.
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.
The new analysis is listed under the Analysis folder in the DQ Repository tree view.