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.
- Open the marketing_leads preparation.
Click the lookup button in the upper right part of the screen to open the lookup
Click Select dataset to select an existing dataset.
- Select the dataset you want to use to perform the lookup, the emails_reference dataset in this example.
From the Current preparation and Lookup
dataset drop-down list, select the columns matching in your main
preparation and your reference dataset, the company and
company_name columns in this example.
In order to perform a lookup, at least one column with matching data must be present in the preparation and dataset that you want to blend.
From the Columns to add drop-down list, select the column
containing the email addresses to add it to the current dataset, the
email_domain column in this example.
- Choose to apply those changes only on the filtered rows or on all of the rows.
- Click Submit to apply the changes.
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.