Selecting the set of columns you want to analyze - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Procedure

  1. Expand DB connections.
  2. In the desired database, browse to the columns you want to analyze, select them and click Finish to close the 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.
    Overview of the Data Preview in the Analysis Settings tab.
    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 an option:
    Option Results
    New Connection Open a wizard and create or change the connection to the data source from within the editor.

    The Connection field on top of this section lists all the connections created in Talend 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 dataset 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.