5. Select Order Lines for certain Products

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

Scenario: You want to get the Order Lines for Products in the Hoodies Product Family, with an order line quantity of 20 or more.

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_Products to the Selected Data Extensions section.

Drag data extension DESELECT_DEMO_Order_Lines on top of DESELECT_DEMO_Products in the Selected Data Extensions section.

Create the relationship:

• Products field: Id
• DESELECT_DEMO_Products WITH MATCHING DESELECT_DEMO_Order_Lines
• Order Line field: ProductId 

Drag field Product Family to the Selected Filters section:

• Criteria: Equals
• Value: Hoodies

Drag field Quantity to the Selected Filters section:

• Criteria: Equal To or Greater Than
• Value: 20

2. Target Definition

Hit the Create Data Extension button, enter a name, eg. Product Order Lines, and press Save.

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

• OrderId, Sales Price and Amount from DESELECT_DEMO_Order_Lines
• Name 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
OrderId, Sales Price and Amount from DESELECT_DEMO_Order_Lines 
and 
Name from DESELECT_DEMO_Products.

The results table shows only Order Lines for Products in the Hoodies Product Family, with an order line quantity of 20 or more.