2 Replies Latest reply: Jan 12, 2016 9:24 AM by Joanna Seldon RSS

    omit 3rd column section access

    Joanna Seldon

      Hiya

       

      i have seen two posts from hic

       

      i have used the following similar content like this in an app, first post from hic

       

      Load Region &'|'& Product as AuthID, Region &'|'& Product as %AuthID  From OrderDetails ;

           Load Region &'|'& Product as AuthID, Region &'|'&'<ANY>' as %AuthID  From OrderDetails ;

           Load Region &'|'& Product as AuthID, '<ANY>'&'|'& Product as %AuthID  From OrderDetails ;

           Load Region &'|'& Product as AuthID, '<ANY>'&'|'&'<ANY>' as %AuthID  From OrderDetails ;


      second post from hic 

      Data Reduction Using Multiple Fields

       

       

      issue i have is this is for section access relating to two columns of data...Region and Product...

       

      i for example need to restrict on columns Region and Product...and CompanyName..

       

      how is this achievable?

       

      please help...