26. Match Contacts with Orders on multiple fields

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get information available for deselect demo contacts alongside their deselect demo orders information you can match the two data extensions on id of deselect demo contacts and contactid of deselect demo orders however, you know that people can exist multiple times in your deselect demo orders data extension with the same id , linked to different accounts therefore, you would like to additionally take accountid into consideration 1\ input on the selections overview screen, click on new to create a new selection drag deselect demo contacts on top of deselect demo orders drag deselect demo orders to the selected data extensions section create the relationship deselect demo contacts field id deselect demo orders with matching deselect demo contacts deselect demo orders field contactid click on the add relationship button and create the second relationship deselect demo contacts field accountid deselect demo orders field accountid 2\ output hit the create data extension button, enter a name, eg contacts with orders, and press save select the following fields by either double clicking on them or dragging them to the section on the right id, accountid, email from deselect demo contacts date, amount from deselect demo orders click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields id, accountid, email, date, amount