I am loading a table from excel into QLikView using
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 ?
my script looks like this
LOAD [Corporate Account],
(ooxml, embedded labels, table is Sheet1);
and it brings one QlikView table per month plus one for accounts name.
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.