[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How do I load an Excel table into QlikView ?

Posted on 2014-07-17
7
Medium Priority
?
1,698 Views
Last Modified: 2014-07-19
Hi all,

I'm trying to load data (held in an Excel 2010 named table) into a QlikView table. However, the LOAD statement only recognises the sheetname (eg Sheet1$), and not the table.

Is there any way I can reference the Excel table name to pull in this data ?

Thanks
Toco
0
Comment
Question by:Tocogroup
  • 5
  • 2
7 Comments
 
LVL 43

Expert Comment

by:Rob
ID: 40203032
All you need to do is as the named range to the query:
LOAD .... FROM $ Sheet1.MyNamedRange

You could also use $a3:$g1678 for instance

If that doesn't work then try loading your excel through odbc as I know it works with the select sql statement
0
 

Author Comment

by:Tocogroup
ID: 40203974
OK.

If my named Excel table is called Budget_Table, how would that fit in with my code, for example,

LOAD .....

FROM
    [..\Data\Budget.xlsx]
    (ooxml, embedded labels, table is Sheet1$);

I can't get it to work
0
 
LVL 43

Expert Comment

by:Rob
ID: 40205707
This is definitely one way to do it using odbc .  I've got a named range "DataRange" that you can see is visible in the wizard

screenshot of odbc
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 43

Expert Comment

by:Rob
ID: 40205723
In fact it's as easy as this when using ODBC:
ODBC CONNECT32 TO [Excel Files;DBQ=C:\folder\excel.xlsx];

table1:
SQL SELECT *
FROM `C:\folder\excel.xlsx`.`NamedRange`;

table2:
SQL SELECT *
FROM `C:\folder\excel.xlsx`.`Sheet1$A1:C400`;

Open in new window

0
 
LVL 43

Accepted Solution

by:
Rob earned 2000 total points
ID: 40205740
As far as I know, it can't be done with the LOAD command.
0
 

Author Closing Comment

by:Tocogroup
ID: 40205998
That's great. Thanks for your help Rob.
0
 
LVL 43

Expert Comment

by:Rob
ID: 40206110
No problem.  I'll keep a look out for any more questions.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question