title: QlikView load table from Excel - merge
body: <p>All,</p>
  
  <p>I am loading a table from excel into QLikView using</p>
  
  <ul>
  <li>New</li>
  <li>Edit Script</li>
  <li>Table Files as datasource --> browse my .xls file</li>
  </ul>
  
  <p>my .xls document is a table with monthly sales: rows are companies, columns are months in 2012 Jan to Dec. Into QlikView, import gives me 13 tables: one with the companies names, and 12 with sales for each months.</p>
  
  <ol>
  <li>how do i get a single table on import, very similar to the table in Excel ? what is it not the default presentation mode ?</li>
  <li>if there is no mean to load the .xls into one single table, how can i merge the tables as to get a single table ?</li>
  </ol>
  
  <p>thanks</p>
  
  <hr>
  
  <p>my script looks like this </p>
  
  <pre><code>LOAD [Corporate Account], 
       Month, 
       Jan, 
       Feb, 
       Mar, 
       Apr, 
       May, 
       Jun, 
       Jul, 
       Aug, 
       Sep, 
       Oct, 
       Nov, 
       Dec
  FROM
  [F:\WORK\corp_account.xls]
  (biff, embedded labels, table is Sheet1$);
  </code></pre>
  
  <p>and it brings one QlikView table per month plus one for accounts name.</p>