How To Use DESelect Segment
Step 2: Target Definition
Can I combine Data Extensions that do not have any matching columns?
note this feature is available in deselect plus and deselect advanced yes deselect has made it possible to combine data extensions that do not have any matching columns with the use of the row number function for example, how can the user combine customers and vouchers data extensions to randomly match one voucher to a customer? true 165,165,165,166left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type true 220,220,221left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type input on the home page, click on new to create a new selection drag the customers data extension to the selected data extensions section output hit the create data extension button, enter a name, e g customers with row number, and press save add all the fields from customers data extension by clicking the add all fields button now, add a new custom value under custom values, click add new value under name, enter row number and hit next choose type apply formula to a field choose type row number on the first drop down list with the label data extension , choose customers on the second drop down list with the label field , choose id on the third drop down list with the label order , choose ascending and hit save add the row number field to the target data extension fields hit save data extension and create preview when the user clicks run preview on the preview screen, the customer with row number data extension should look like this true 132,132,132,132,133left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type the user can now click on the run button to run the selection repeat the steps accordingly for vouchers data extension in the end, the target data extension should look like this true 165,165,165,166left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type now, the user can combine the customers and vouchers data extension using the row number column