8. Select the Products in one of several Product Families

Note: The scenario below uses data from the DESelect Demo Data Package.

Scenario: You want to get the name of all products in product family Jackets, Hoodies, Trousers or Shirts.

Watch the video tutorial on how to implement this scenario or follow the steps below.

1. Input

On the selections overview screen, click on New to create a new selection. 

Drag DESELECT_DEMO_Products to the Selected Data Extensions section.

Drag field Product Family to the Selected filters section.

• Criteria: In
• Value: Jackets,Hoodies,Trousers,Shirts

2. Output

Hit the Create Data Extension button, enter a name, eg. Known Subscribers, and press Save.

Select the following fields by either double-clicking on them or dragging them to the section on the right:

• Name, Product Family from DESELECT_DEMO_Products

Click Save Data Extension.

3. Preview

When you click Run Preview on the Preview screen, a results table will be shown with fields Name and Product Family. The results table shows only Products in product family Jackets, Hoodies, Trousers, and Shirts.