Section Access Is not restriction the field values

[avinashkk696]

Hello Experts,

I have the below section access code. It seems like it is not working as expected.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NAME

    ADMIN, ADMIN, 123, KUMAR

    USER, USER1, 1234, KRIS

    ADMIN, VISU, 111, MONA

];

Section Application;

table1:

LOAD

LOAD EmpID,

     upper(Name) as NAME,

     State,

     Dept,

     Salary,

     LastModified

FROM

(ooxml, embedded labels, table is Sheet1);

I want to restrict the field values in Name Field according to the script above. 

[krishnacbe · Accepted solution]

Hi

You need to enable the checkbox "Initial Data Reduction Based on Section Access" and "Strict Exclusion" in Document Properties -> Opening Tab

[MK9885]

Check this box in Document Properties>Opening

For me if I login as ADMIN, I see my name as KUMAR and it is working fine.

If you want ADMIN to view all names (see below script) then you should add all the NAMES to Section Access Inline or define it somewhere in XL.

LOAD EmpID,

     Upper(Name) as NAME,

     State,

     Dept,

     Salary,

     LastModified

FROM..............

Star is *;

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NAME

    ADMIN,  , 123, *

    USER, USER1, 1234, KRIS

    ADMIN, VISU, 111, MONA

    USER, , 1, Ramesh

    USER, , 2, Steve

    USER, , 3, John

    USER, , 4, Sofie

    USER, , 5, Henry

    USER, , 6, Mark

    USER, , 7, Andrew

    USER, , 8, Khedar

    USER, , 9, Steffy

    USER, , 10, Morog

    USER, , 11, Rex

    USER, , 12, Malathi

    USER, , 13, Rajeswari

    USER, , 14, Vijay

    USER, , 15, Raj

    USER, , 16, Keshav

    USER, , 17, Balaji

    USER, , 18, KUMAR

];

Section Application;

[ger_alegria]

You have to enable the checkbox "Initial Data Reduction Based on Section Access" and enable the checkbox "Strict Exclusion".

Go to Document Properties and Opening Tab.

With this your section application will works