Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Section access help

I’m hoping someone can help (and it’s something obvious that I missing) - I'm very new to Qlik Sense so forgive what may be some obvious mistakes.


I have created an excel spreadsheet for me called ACL.XLSX which has four columns. The headers of these columns are:

ACCESS, USERID, GROUP and CODE

The section access in the data load editor looks like this:


section access;

//Create authorisation table

LOAD

  ACCESS,

    USERID,

    GROUP,

    Upper(CODE) as %AUTHID

FROM [$(vL.ImportPath)/ACL.XLSX]

(ooxml, embedded labels, table is [Auth_Table]);

section application;




I get this error when I try to Load Data:

Started loading data

The following error occurred:

Field not found - <ACCESS>

The error occurred here:

LOAD ACCESS, USERID, GROUP, Upper(CODE) as %AUTHID FROM [lib://Import (win-gefg5c269k8_vmoore)/ACL.XLSX] (ooxml, embedded labels, table is [Auth_Table])

Data has not been loaded. Please correct the error and try loading again.



I know the vl.ImportPath is correct and I know the name of the file is correct (I know this because I changed it in the section access to be “ACL123.XLSX” and I got a different error saying it couldn’t find the file.


I just cannot understand why it can’t find the field “ACCESS”. If I comment out that line, I get the same error message but it says it can’t find “USERID”.

Is it something obvious or something I am missing?


I have tried all using square brackets for the field names, quotes etc. but still get the same error message.

1 Solution

Accepted Solutions
miskin_m
Contributor

Re: Section access help

Hi

LOAD ACCESS, USERID, GROUP, Upper(CODE) as %AUTHID FROM [lib://Import (win-gefg5c269k8_vmoore)/ACL.XLSX] (ooxml, embedded labels, table is [Auth_Table])


is the table you want to refer or like it is some other sheet in same excel book

6 Replies
arasantorule
Contributor III

Re: Section access help

Hi,

Can you share the sample excel file with us?

Thanks.

Not applicable

Re: Section access help

Hi,

Just worked out what my problem was:

My sheet was named "Authorising_Table" instead of "Auth_Table".

Thanks for the reply though :-)

bhupesh_gupta
Contributor

Re: Section access help

Hi,

Try using the absolute path instead of the variable while loading the ACL.XLSX.

Thanks

nurflechl
New Contributor III

Re: Section access help

Hi,

1) You need to use backslash instead of slash in the Excel path:  [$(vL.ImportPath)\ACL.XLSX] would be correct

2) However, if you are using deployment framework variables, you don't need any of them, because the Import path Ends with "\" for example: ...\MyProject\8.Import\

In that case, you just need :  [$(vL.ImportPath)ACL.XLSX].

You should check the variable $(vL.ImportPath) first and solve this Problem with either 1 or 2 as explained above.

lakshmikandh
Valued Contributor II

Re: Section access help

is the data connection owner is same as the user you are using for data loading ?

miskin_m
Contributor

Re: Section access help

Hi

LOAD ACCESS, USERID, GROUP, Upper(CODE) as %AUTHID FROM [lib://Import (win-gefg5c269k8_vmoore)/ACL.XLSX] (ooxml, embedded labels, table is [Auth_Table])


is the table you want to refer or like it is some other sheet in same excel book