OMIT Section Access do not hide key fields

[grassomirco]

Hello everyone

I'm tring to hide an entire qualified table with the Section Access.I am not able to hide the primary key. Is there a way to do it? Am I doing something wrong?

---------- Script Qlik ------------

[TableToRemove]:

xx_Field1,

xx_Field2,

xx_Field3,

xx_keyField

FROM

...

----------------------------------------

------------ Section Access Txt -----------------

ACCESS;USERID;USER;PASSWORD;NTNAME; OMIT

ADMIN; User1; User1; User1; NTName1; xx_*

....

--------------------------------------------------------------

What I find after reloading data is [TableToRemove] is the table with only xx_keyField.

I want to hide ALL the table.

Thanks

Mirco

[Gabriel]

Hi,

OMIT will not hide the table for you.

You should have to do the following

SECTION ACCESS;

Security Table Name

FIELD A

,FIELD B

FROM SOURCE;

SECTION APPLICATION

This will hide the table.

Hopefully I understand what you want to achieve.

[grassomirco]

Hi Gabriel,

what I would like to do is hide all the fields on a specific table. With OMIT I can't omit the key field.

Unfortunately I haven't understood what you mean exactly.

Let's suppose I have to hide with the section access the table below:

TABLE:

LOAD

     Tb_Field1,

     Tb_Field2,

     Tb_Field3,

     Tb_keyField

FROM [source];

What should I text in my Section Access?

Section Access;

LOAD *

RESIDENT TABLE;

Section Application;

I am not sure it will work properly.