Load Excel file into QLikView - merge tables

[#1]

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

(ooxml, embedded labels, table is Sheet1);

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

[MK_QSL]

can you please load your sample data file?

[#3]

I enclose source xls file and obtained .qwv

[MK_QSL]

use this

[#5]

is it possible to open it in personal edition, as not created by me ? it seems that it is not

would you like to share how you built it, or share your script when based on a script ?

[MK_QSL]

Write below script in your script editor

TableName:

CrossTable(Month, Data)

LOAD [Corporate Account],

     Jan,

     Feb,

     Mar,

     Apr,

     May

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

[MK_QSL]

Make sure the location of the file should be according  to your file placed in your drive

[#8]

thks a lot

using your script, i am getting the enclosed file. I now have three tables: Corporate accounts, Months and Data. Data is a one column table, so that it is not possible to read all the data as entered in .xls file.

Further help would be much appreciated : )

[MK_QSL · Accepted solution]

Right Click

new sheet object

Table BOx

add all

OK