Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
grassomirco
Partner - Contributor II
Partner - Contributor II

OMIT Section Access do not hide key fields

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

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

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
Partner - Contributor II
Partner - Contributor II
Author

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.