title: What is the best way to use lookup tables in QlikView?
body: <p>In QlikView, I have a table <strong>Data</strong> and one database table <strong>A</strong>. Table <strong>A</strong> should be used twice (<strong>A_Left</strong>, <strong>A_Right</strong>). (Table A can have thousands of entries.) </p>
  
  <p>My load script is:</p>
  
  <pre><code>A_Left:
  Load a_id_left,
       a_name_left
  inline [
    a_id_left, a_name_left
    1, 'nwsnd'
    2, 'dcsdcws'
    3, 'fsdf'    ];
  
  A_Rigtht:
  Load a_id_right,
       a_name_right
  inline  [
    a_id_right, a_name_right
    1, 'nwsnd'
    2, 'dcsdcws'
    3, 'fsdf'    ];
  
  Data:
  Load id, 
       a_id_left,
       a_name_left as 'Name_Left',
       a_id_right,
       a_name_right as 'Name_Right',
       data
  inline [
    id, a_id_left, a_right_id, data
    1, 1, 2, 37
    1, 1, 3, 18
    1, 2, 3, 62
  ];
  </code></pre>
  
  <p>So my question is: What is the best way to use lookup tables in QlikView?
  (Should I use <code>MAPPING</code> and/or <code>ApplyMap</code>? Why? Is that faster?)</p>
  
  <p>One other part of the question is: Would it help change the data structure from star to table? 
  (I know that would cost more memory.) And, by the way: How could I put all data in one table
  so that I can store it completely in one QVD file?</p>
  
  <p>Thanks for help an ideas.</p>