Create a Filtered Data Extension
- Hover over Subscribers.
- Click Data Extensions.
- Click Create.
- Select Filtered Data Extension.
- Click OK.
- Select a standard data extension to filter as the source data extension.
- Click OK.
- Drag Fields, Filters, orMeasure from the left column to the Create Filter canvas. Use the following table as a reference to building out your filter. Note Be sure to choose an operator that makes sense with the type of field you chose. Forexample, do not use the less than operator with a text field. For attributes with type equalto date, only the following operators are supported: is equal to, is not equal to, is greaterthan and is less than.
- Select an AND or OR operator. You can group your criteria by hover over the grouping operator so that it turns a darker blue, and click to change the operator. If you choose AND, the record must meet all criteria to be included in the group. If you choose OR, the record must meet one of the criteria, not necessarily all criteria, to be included in the group.
- Click Save & Build.
- Enter a Name for the filtered data extension.
- Enter a Description for the filtered data extension.
- Select a folder in which to store the filtered data extension. Or select NewFolder to create a folder to store the filtered data extension.
- Click Save.