Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You want to get all Contacts that have an email address from domain superrito.com from a Data Extension.
Watch the video tutorial on how to implement this scenario or follow the steps below.
1. Selection Criteria
On the Selections Overview screen, click on New to create a new Selection.
Drag Data Extension DESELECT_DEMO_Contacts to the Selected Data Extensions section.
Drag field Email to the Selected Filters section:
- Criteria: Ends With
- Value: @superrito.com
2. Target Definition
Hit the Create Data Extension button, enter a name, eg. Supperrito emails, and press Save.
Select the following fields by either double-clicking on them or dragging them to the section on the right:
- First Name, Last Name and Email from DESELECT_DEMO_Contacts
Click Save Data Extension.
When you click Run Preview on the Preview screen, a results table will be shown with fields First Name, Last Name, and Email. The results table shows only Contacts with an email ending in @superrito.com.