Section Access: Admin Access work fine, not User Acess

[adnene__]

Hello,

I am using Section access and what I noted is that:
- When in ACCESS column I use 'ADMIN', everything works fine i terms of limiting data I user "country code".
- When in ACCESS column I use 'USER', I got 'access denied'.

Do you have an idea what might be the problem?

Script:

SA:
LOAD
    upper("ACCESS") 			as ACCESS,
    upper("USERID") 			as USERID,
    Upper(COUNTRY_CODE) 		as COUNTRY_CODE

FROM [PATH_TO_FILE\Section Access.xlsx]
(ooxml, embedded labels, table is Access);

// Section Access implementation
Section Access;
LOAD
    "ACCESS",
    "USERID",
    COUNTRY_CODE
Resident SA;

Section Application;

Drop Table SA;

[agigliotti]

could you attach your section access script to look at ?

[adnene__]

I edited the post to include it

[agigliotti]

i can't see the data reduction in secion application, did you use it in some way?

[adnene__]

The data reduction is supposed to be the column "REGION_CODE" in the data, right?
Is did use it, but I use a lot of scripts to do it. And since it works fine whith the ACCESS 'ADMIN', I thought it's useless to think the problem was in the data.

[agigliotti]

you need to make a link between section access table and section application table.
let's try with the below code:
Section Access;
SA:
LOAD
upper("ACCESS") as ACCESS,
upper("USERID") as USERID,
Upper(COUNTRY_CODE) as SA_COUNTRY_CODE
FROM [PATH_TO_FILE\Section Access.xlsx]
(ooxml, embedded labels, table is Access);

Section Application;
tab_1:
load
COUNTRY_CODE,
COUNTRY_CODE as SA_COUNTRY_CODE,
...
from your_data_table;

I hope it helps.