Dynamically using the data from another dataset

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
Talend Data Services Platform
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend ESB
Talend Data Management Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

The lookup feature matches data from the current dataset with its counterpart in a reference dataset.

On the one hand, you have the marketing_leads dataset, that you are currently working on, that contains information about the company where the listed customers are working. On the other hand, the emails_reference contains a list of companies, and the email domain that they are using.

You are going to do a lookup on the emails_reference dataset, and extract the information about email domains to match them with the companies from the marketing_leads dataset.

Before you begin

To perform the lookup on the emails_reference, you have to import it by using the Add dataset button in the Datasets view of the homepage.

Procedure

  1. Select the column on which you want to perform the lookup, the Company column in this example.
    This is the column that can be found in the source dataset, as well as the reference dataset. There must always be a common column between two datasets to perform a lookup.
  2. Click the lookup button to open the lookup panel.
  3. Click the button and, in the dialog box that opens, select the dataset you want to use to perform the lookup, the Emails_Reference dataset in this example.
  4. Click Add.
  5. In the lookup window that opens in the bottom half of your screen, click the Company_Name column.
  6. Select the Add to Dataset check box.
  7. Point your mouse over the Confirm button to preview the changes.
  8. Click the Confirm button to apply those changes.

Results

The Email_Domain column is added to the marketing_leads dataset, next to the Company column.

This information about email domains will be added to the first names and last names from the duplicated column to create the complete email addresses.