Using the email domains from another dataset
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 need to import it by using the Add dataset button in the Datasets view of the homepage.
Procedure
-
Click the lookup button in the upper right part of the screen to open the lookup
panel.
-
Click Select dataset to select an existing dataset.
-
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.
Results
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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!