Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Creator
Partner - Creator

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

View solution in original post

6 Replies
arasantorule
Creator III
Creator III

Hi,

Can you share the sample excel file with us?

Thanks.

Not applicable
Author

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
Creator
Creator

Hi,

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

Thanks

Anonymous
Not applicable
Author

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
Specialist II
Specialist II

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

miskin_m
Partner - Creator
Partner - Creator

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