How to create a Target Data Extension on the fly in DESelect Segment?

Perform the following steps on the Output screen:

1. Click the Create Data Extension button.
2. You need to provide the name, description, and location of your Data Extension.
3. Indicate in the Options if your new Data Extension needs to be sendable and/or testable and if you need to enable the Retention Settings.
4. Click Continue.
5. Now you can see all the fields from the Selected Data Extensions on the left.
6. Choose the fields you would like to see in your new Target Data Extension. Select them by:
   • drag-and-dropping them to the right.
   • double-clicking on them.
   • clicking the Add all fields button to add all fields of a selected Data Extension at once.
7. Fields on the right-hand side will constitute your Target Data Extension.
8. On the Target Data Extension fields, you can click on the pencil icon and see the details of the field (Field Information). You can edit: name, length of the field, and indicate if it’s a Primary Key and/or Nullable.

1. If you are satisfied with your new Data Extension, click Save Data Extension. Alternatively, click Cancel to return to the mapping screen without creating the new Data Extension.
2. Click Create.

Your new Data Extension is now created in Marketing Cloud and available to use within DESelect Segment to write the results of your Selection.

Note: a mapping has automatically been created as well, so you don't have to worry about that anymore. For example, if you created a Target Data Extension with fields Id and Email from a Contacts Data Extension, the Id field of Contacts will be mapped to the Id field of your new Data Extension, and the same applies to the Email field.