Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

(ooxml, embedded labels, table is Sheet1);

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Right Click

new sheet object

Table BOx

add all

OK

View solution in original post

8 Replies
MK_QSL
MVP
MVP

can you please load your sample data file?

Not applicable
Author

I enclose source xls file and obtained .qwv

MK_QSL
MVP
MVP

use this

Not applicable
Author

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
MVP
MVP

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
MVP
MVP

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

Not applicable
Author

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
MVP
MVP

Right Click

new sheet object

Table BOx

add all

OK