8 Replies Latest reply: Dec 21, 2013 10:47 AM by Manish Kachhia RSS

    Load Excel file into QLikView - merge tables

      All,

      I am loading a table from excel into QLikView using

      • New
      • Edit Script
      • Table Files as datasource --> browse my .xls file

      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.

      1. how do i get a single table on import, very similar to the table in Excel ? what is it not the default presentation mode ?
      2. 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 ?

      thanks


      my script looks like this

      LOAD [Corporate Account],

           Jan,

           Feb,

           Mar,

           Apr,

           May

      FROM

      [F:\Book1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

      and it brings one QlikView table per month plus one for accounts name.