Defining the set of columns to be analyzed

Before you begin

You have defined at least one database connection in the Profiling perspective of Talend Studio.

In the DQ repository tree view, expand Data Profiling and right-click Analyses > New analysis.
The Create new analysis wizard opens.
Select Table > Column set analysis and click Create..
Enter a name.
Optional: Set column analysis metadata (Purpose, Description) in the corresponding fields.
Click Next.
From the Connection menu, select the connection from the Connection list and click Next.
From the Columns menu, click Select columns and select the database and the columns you want to analyze, and click OK.
In this example, you want to analyze a set of six columns in the customer table: account number (account_num), education (education), email (email), first name (fname), second name (Iname) and gender (gender). The statistics presented in the analysis results are the row count, distinct count, unique count and duplicate count which all apply on records (values of a set of columns).

A data preview is displayed.
Click Next.

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