How to use OMIT in section access?

[Anonymous]

I have the below section access script. I want USER1 unable to see Cost. How can I achieve it by using OMIT.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OMIT

    ADMIN, ADMIN, ADMIN123

    USER, USER1, USER123, COST

];

Section Application;

LOAD * INLINE [

    Cost, COST

];

excel sheet is also attached.

many Thanks

[fkeuroglian]

Hi John

Maybe -

Check the selected option  “Settings” -> “Document Properties” -> “Opening” ->Strict Exclusion is checked?

try this or put and upper function in the COST field

good luck

Fernando

[prieper]

Did you set "Initial Datareduction ...."?

Peter

[Anonymous]

HI all, I have checked both "Initial data Reduction" and "Strict exclusion" Still, Cost field is showing for user1. Fernando, what do you mean by put upper function in cost field? Excel sheet has "Cost" and I have "COST" under OMIT in section access. Then in section application, I have "mapped" "COST" to "Cost" i am hoping this is the correct way. If you see any thing can you please advise..?

[Colin-Albert · Accepted solution]

You need to rename the Cost field to COST, or load the field twice from excel as Cost & COST.

The field names must be uppercase for section access.

I do not believe your one line inline load does anything, it just creates an empty table.

[Anonymous]

Thanks Colin, that worked.