Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You want to get the Company Name of all Accounts that have more than one Order.
Note: this scenario uses feature Formula's in Subqueries, which is available in DESelect Plus and Advanced.
1. Selection Criteria
On the selections overview screen, click on New to create a new selection.
Drag data extension DESELECT_DEMO_Accounts to the Selected Data Extensions section.
Drag field Id to the Filters section:
- Choose criteria: In Results
- From the dropdown select Data Extension DESelect_DEMO_Orders.
- Choose field AccountId
Now we have indicated we want to get the Accounts whose Id appears in the Orders data extension. However, we want to filter only the Accounts with more than 1 Order.
- Click on the fx button on the created filter.
- Keep the formula at its default (Count).
- Choose criteria: more than.
- Keep the value at its default (1).
We will now be filtering based on the number of Orders per Account; this has to be more than 1.
2. Target Data Extension
Hit the Create Data Extension button, enter a name, eg. Accounts with more than 1 Order, and press Save.
Select the following fields by either double-clicking on them or dragging them to the section on the right:
- Company Name from DESELECT_DEMO_Accounts
Click Save Data Extension.
When you click Run Preview on the Preview screen, a results table will be shown with field Company Name from DESELECT_DEMO_Accounts.
The results table shows only Accounts that have more than 1 Order.