Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Load Excel file into QLikView - merge tables

Right Click

new sheet object

Table BOx

add all

OK

8 Replies

Re: Load Excel file into QLikView - merge tables

can you please load your sample data file?

Not applicable

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

I enclose source xls file and obtained .qwv

Re: Load Excel file into QLikView - merge tables

use this

Not applicable

Re: Load Excel file into QLikView - merge tables

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

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

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

Not applicable

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

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

Right Click

new sheet object

Table BOx

add all

OK

Community Browser