title: Difference between two tables
body: <p>I have two tables like this:</p>
  
  <pre><code>Table1:
  LOAD * INLINE [
  OrderItem
  OI1
  OI2
  OI3
  OI4
  OI6
  ];
  
  Table2:
  LOAD * INLINE [
  OrderItem
  OI2
  OI3
  OI4
  OI5
  OI6
  ];
  </code></pre>
  
  <p>Now I want a third table which shows me that <strong>only</strong> OI5 is not in "Table1"!
   A Listbox solution is also ok.</p>
  
  <p>I tried some things with joins bit it didn't work. I also read <a href="https://community.qlik.com/thread/32944" rel="nofollow noreferrer">this</a> 
  but it only showed me the difference between the two tables in a listbox. See below:</p>
  
  <pre><code>Table1:
  LOAD * INLINE [
  OrderItem
  OI1
  OI2
  OI3
  OI4
  OI6
  ];
  
  Concatenate(Table1)
  Table2:
  LOAD * INLINE [
  OrderItem
  OI2
  OI3
  OI4
  OI5
  OI6
  ];
  
  INNER JOIN (Table1)
  LOAD *
  WHERE "Only in One Table?"
  ;
  
  // Here I want "OI5" as an output
  Difference:
  LOAD 
      OrderItem,
      if(count(OrderItem)&lt;2,-1) as "Only in One Table?"   
  RESIDENT Table1 GROUP BY OrderItem
  ;
  </code></pre>
  
  <p>Result:</p>
  
  <p><a href="https://i.stack.imgur.com/VV3S2.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VV3S2.jpg" alt="enter image description here"></a></p>
  
  <p>Thanks!</p>