title: Qlikview joins that doesn't join on all matching column names
body: <p>I'm new to Qlikview and looking for some answers regarding scripting. How can I create Qlikview joins that just join on a specific column (and not all that are having a matching name)? Let's say that I'm having the following tables:</p>
  
  <p><em>Employee</em></p>
  
  <pre><code>Id     |    Person   |    DepartmentID   |    Flags
  1000   ,    Bob      ,      2001         ,        1000000
  1001   ,    Sue      ,      2002         ,        1100000
  </code></pre>
  
  <p><em>Department</em></p>
  
  <pre><code>Id    |    Name    |    Flags
  2001  ,    HR      ,    01101111
  2001  ,    R&amp;D      ,    1100000
  </code></pre>
  
  <p>What is the best way of joining those tables on the DepartmentID &lt;-> ID field? The data is provided by SQL selects. I'm thinking of writing SQL views using unique names would be one idea, but there must be a simpler way. Please advise.</p>