Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agaetisproject
Not applicable

Load a named table from Excel

I am trying to load a named table from Excel but can't figure out the script to achieve this.

Can someone help me?

The named Table is called Personnel and appears on Sheet1

LOAD *

FROM [lib://FIlename.xlsx]

(ooxml, embedded labels, table is Personnel);

Thanks a lot in advance.

Tags (1)
6 Replies
sunny_talwar
Not applicable

Re: Load a named table from Excel

Is this Qlik Sense or QlikView?

May be try this:

Personnel:

LOAD *

FROM [lib://FIlename.xlsx]

(ooxml, embedded labels, table is Sheet1);

MindaugasBacius
Not applicable

Re: Load a named table from Excel

If you have few tables in one excel sheet like in picture below:

Screenshot_2.png

While loading data you should take Transformation steps first:

Screenshot_3.png

Gysbert_Wassenaar
Not applicable

Re: Load a named table from Excel

Usually you create a connection to a file system folder and add it to your library and your file exists in that folder:

LOAD *

FROM [lib://MyFolder/Filename.xlsx]

(ooxml, embedded labels, table is Personnel);

Check that your created a connection in your library first. Simply typing lib://something doesn't create a connection in your library.

Alternatively use the Data Manager to load the data from the excel file. You'll be walked through a few screens and the connection will be made for you and the data loaded. You should see the tables, including the named tables, in excel on the third screen:

comm215136.png


talk is cheap, supply exceeds demand
agaetisproject
Not applicable

Re: Load a named table from Excel

Thank you. It seems I wasn't clear. My issue is not how to load a table but how to load a named table.

In Excel, you can create an object Table and give it a name. From the name manager, you can reuse the object and its column. I wan wondering whether Qlikview can 'read' the named objects of a workbook, like a table or a named range.

Is that clearer?

richard_chilvers
Not applicable

Re: Load a named table from Excel

I always struggle with formatting the LOAD for an Excel file.

Have you tried using the <Table Files> button, to activate the Wizard ?

Gysbert_Wassenaar
Not applicable

Re: Load a named table from Excel

I wan wondering whether Qlikview can 'read' the named objects of a workbook, like a table or a named range.

Is that clearer?

Both Qlikview and Qlik Sense have no problems loading data from tables defined as Named Ranges in Excel.


talk is cheap, supply exceeds demand