11. Select Contacts with the Company Name of the Account they are related to

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get all contacts with the company name of the account they are related to https //www youtube com/watch?v=zooghgk4s84 or follow the steps below 1\ input on the selections overview screen, click on new to create a new selection drag deselect demo contacts to the selected data extensions section drag deselect demo accounts on top of deselect demo contacts in the selected data extensions section create the relationship contacts field accountid deselect demo contacts with matching deselect demo accounts accounts field id 2\ output hit the create data extension button, enter a name, eg contacts with account info, and press save select the following fields by either double clicking on them or dragging them to the section on the right select fields first name , last name from deselect demo contacts company name from deselect demo accounts click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields first name, last name, company name