topic Section access from Excel file in QlikView

Section access from Excel file

Thu, 27 Oct 2011 12:55:05 GMT

Good day,

I have the following Excel file:

If I create a section access with the following code, it doesn't work:

Section Access;
Directory;
LOAD [ACCESS], 
     User AS [USERID], 
     Pwd AS [PASSWORD]
FROM
access.xls
(biff, embedded labels, table is Access$);
   Section Application;

If I rename the fields in my Excel file, it works.

So I guess it's the "AS" expression that isn't accepted in the section access.

If I don't use the "embedded labels"

(biff, no labels, header is 1 lines, table is Acces$);

and use "@1 AS USERID, @2 AS PASSWORD", it works.

Why can't I use embedded labels and rename fields (using "AS" ) in the section access ?

Section access from Excel file

Thu, 27 Oct 2011 13:09:24 GMT

hi,

try with square brackets:

LOAD [ACCESS], [User] AS [USERID], Pwd AS [PASSWORD] FROM access.xls (biff, embedded labels, table is Access$);

Re: Section access from Excel file

Thu, 27 Oct 2011 13:15:21 GMT

It doesn't work either.

Section access from Excel file

Anonymous — Thu, 27 Oct 2011 13:15:28 GMT

Nicolas,

I don't see a reason for this problem, except a possibility that there is a space in Excel after User, like this: 'User '. Loading into the section access is not different from any other data load.

And, an advice - to make sure your section access works, use upper() function for all fields, e.g.:

upper(User) as USERID

Section access from Excel file

Thu, 27 Oct 2011 13:20:00 GMT

> a possibility that there is a space in Excel after User

There is no extra space.

> to make sure your section access works, use upper() function for all fields

I'm used to it, but for this simple exemple, I wrote the simpliest code to be easily understood.

Section access from Excel file

Anonymous — Thu, 27 Oct 2011 13:25:21 GMT

Looks like I'm wrong - load works differently if it is "section access" - You must have headers in upper case in Excel file: USER, PWD.

Re: Section access from Excel file

Fri, 13 Nov 2015 15:07:06 GMT

looks you need check on file opening on document properties> opening