topic Re: Re: Load Excel file into QLikView - merge tables in QlikView

Load Excel file into QLikView - merge tables

Sat, 21 Dec 2013 14:31:31 GMT

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.

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

Re: Load Excel file into QLikView - merge tables

MK_QSL — Sat, 21 Dec 2013 14:40:46 GMT

can you please load your sample data file?

Re: Re: Load Excel file into QLikView - merge tables

Sat, 21 Dec 2013 14:50:29 GMT

I enclose source xls file and obtained .qwv

Re: Load Excel file into QLikView - merge tables

MK_QSL — Sat, 21 Dec 2013 14:55:59 GMT

use this

Re: Load Excel file into QLikView - merge tables

Sat, 21 Dec 2013 15:06:08 GMT

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 ?

Re: Load Excel file into QLikView - merge tables

MK_QSL — Sat, 21 Dec 2013 15:09:04 GMT

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);

Re: Load Excel file into QLikView - merge tables

MK_QSL — Sat, 21 Dec 2013 15:16:18 GMT

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

Re: Re: Load Excel file into QLikView - merge tables

Sat, 21 Dec 2013 15:39:41 GMT

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 : )

Re: Load Excel file into QLikView - merge tables

MK_QSL — Sat, 21 Dec 2013 15:47:33 GMT

Right Click

new sheet object

Table BOx

add all