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.com 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.