Below you can find an overview of all scenarios that are available to do with the data in the Demo Data Package.
| Scenario | What functionality does it cover? | SQL alternative |
| DESelect Enable | ||
| Select Contacts with the Company Name of the Account they are related to | Defining relations: with matching | INNER JOIN |
| Select Contacts that are known Subscribers | Defining relations: with matching Data Views |
INNER JOIN |
| Select Accounts without Contacts | Defining relations: without matching | LEFT JOIN with IS NULL |
| Select the Products in one of several Product Families | Filters: in | IN |
| Select the Contacts with an email from a given domain | Filters: contains | LIKE '%value%' |
| Exclude Contacts in a data extension from a campaign | Defining relations: without matching | LEFT JOIN with IS NULL |
| Add results of one selection to the results of another selection | Data action: append | UNION |
| DESelect Plus | ||
| Add a fixed value to your results | Custom values: fixed value | SELECT 'value' AS |
| Add a dynamic value to your results | Custom values: dynamic value | CASE WHEN THEN |
| Select Contacts that have not received any emails in the last 14 days | Filters: Not In Results, dynamic dates Data Views |
NOT IN subquery |
| DESelect Advanced | ||
| Get the Order Line with the highest Quantity for each Product (deduplication) | Prio deduplication | ROW_NUMBER |
Comments
0 comments
Please sign in to leave a comment.