2 Replies Latest reply: May 22, 2015 5:59 AM by Mirco Grasso RSS

    OMIT Section Access do not hide key fields

    Mirco Grasso

      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

        • Re: OMIT Section Access do not hide key fields
          Gabriel Oluwaseye

          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.

            • Re: OMIT Section Access do not hide key fields
              Mirco Grasso

              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.