title: select based on lookup table
body: <p>I have following problem.
  I want to select data from one table based on lookup table. This is the easy part. 
  But in the results I want a new column which is based on the lookup table.</p>
  
  <p>Here a example scenario:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-css lang-css prettyprint-override"><code>LOOKUP-TABLE
  Account|Company|Area|origin|aktive
  -----------------------------------
  0020200|xqzComp|0100|HK1000|1
  0020300|xyzComp|0100|HK2000|0
  0020400|xxzComp|0100|HK3000|0
  0020500|xbzComp|0100|HK4000|1
  
  
  DATA-TABLE
  Account|Company|Area|State|keyFig1|KeyFig2
  -------------------------------------------
  0020200|xqzComp|0100|GERM|100.000|200.000
  0020400|xxzComp|0100|AUST|210.000|130.000
  0020400|xxzComp|0100|GERM|222.000|111.000
  0020500|xbzComp|0100|GERM|111.000|212.000
  
  
  RESULT:
  Account|Company|Area|State|keyFig1|KeyFig2|new column
  ------------------------------------------------------
  0020200|xqzComp|0100|GERM|100.000|200.000 |is_HK100
  0020500|xbzComp|0100|GERM|111.000|212.000 |not_HK100</code></pre>
  </div>
  </div>
  </p>
  
  <p>The fields Account, Company, Area are all key-fields for the inner join.
  But how to create the colum "new column" which is based in the column "origin" of the lookup table</p>
  
  <p>Thank you very much!</p>