title: How can I create a relationship in excel for multiple columns?
body: <p>I'm trying to create a relationship between two tables in powerpivot. However, my tables don't have any keys. What I would like to do is create a SQL-Unique-Constraint-like relationship, which is based upon multiple values combined, being the key.</p>
  
  <p>For example: </p>
  
  <p>Table1 columns are First, Last, Address, Phone</p>
  
  <p>Table2 columns are the same.</p>
  
  <p>I want to create a relationship in excel that is the equivalent of</p>
  
  <p><code>select * from Table1 full join Table2 on 1.Fist=2.First and 1.Last=2.Last and 1.Address=2.Address</code></p>
  
  <p>However, the create relationship dialogue doesn't allow multiple columns to selected. I tried going the route of just creating multiple 1-column relationships. However, relationships also cannot include columns were there are duplicate values in the column.</p>
  
  <p>I have a feeling I may just be approaching accomplishing this from the wrong direction. Any help is appreciated! Thank you.</p>