topic Re: Load a named table from Excel in QlikView

Load a named table from Excel

agaetisproject — Sat, 30 Apr 2016 22:06:19 GMT

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.

Re: Load a named table from Excel

sunny_talwar — Sun, 01 May 2016 16:28:45 GMT

Is this Qlik Sense or QlikView?

May be try this:

Personnel:

LOAD *

FROM [lib://FIlename.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Load a named table from Excel

MindaugasBacius — Sun, 01 May 2016 18:32:56 GMT

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

While loading data you should take Transformation steps first:

Re: Load a named table from Excel

Gysbert_Wassenaar — Mon, 02 May 2016 09:03:15 GMT

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:

Re: Load a named table from Excel

agaetisproject — Tue, 03 May 2016 10:39:37 GMT

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?

Re: Load a named table from Excel

richard_chilvers — Tue, 03 May 2016 10:56:40 GMT

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

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

Re: Load a named table from Excel

Gysbert_Wassenaar — Tue, 03 May 2016 12:33:05 GMT

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.