Selecting the set of columns you want to analyze - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

Procedure

  1. Expand DB connections.
  2. In the desired database, browse to the columns you want to analyze, select them and then click Finish to close this New analysis wizard.
    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).
    The analysis editor opens with the defined analysis metadata, and a folder for the newly created analysis is displayed under Analyses in the DQ Repository tree view.
    A sample data is displayed in the Data Preview section and the selected columns are displayed in the Analyzed Column section of the analysis editor.

    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).

  3. In the Data preview section, select:
    Option To...
    New Connection open a wizard and create or change the connection to the data source from within the editor.

    For further information about how to create a connection to data sources, see Connecting to a database and Connecting to a file.

    The Connection field on top of this section lists all the connections created in the Studio.

    Select Columns open the Column Selection dialog box where you can select the columns to analyze or change the selection of the columns listed in the table.

    From the open dialog box, you can filter the table or column lists by using the Table filter or Column filter fields respectively.

    n first rows or n random rows list in the table N first data records from the selected columns or list N random records from the selected columns.
    Refresh Data display the data in the selected columns according to the criteria you set.
    Run with sample data run the analysis only on the sample data set in the Limit field.
  4. In the Limit field, set the number for the data records you want to display in the table and use as sample data.