Section access

[BI_Dev]

I have 2 tables as below.

TM ID, TM Confidential

1, Yes

2, No

3 No

];

PM ID, PM Confidential

100, No

200, Yes

300, No

];

I want to apply section access to Hide PM Confidnetial = 'Yes' and TM Cofidential = 'Yes' from  ABC@qlik.com.How an I acheive that ?

[Muthukumar_77]

Hi,

You can use OMIT in section access, Below Eg:

TM ID, TM Confidential
1, Yes
2, No
3 No
];

PM ID, PM Confidential
100, No
200, Yes
300, No
];

Section Access;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN123
USER, USER1, USER123, TM ID
USER, USER1, USER123, PM ID
];

Section Application;

[BI_Dev]

But section access should have the common field with the other tables right ? 

In section access table you dont have the PM Confiddential/TM Confidential specified.How does it know on data reduction ?

[rubenmarin]

Hi, you can add a new field to each table, wich will be used to reduction with SA.

Table1Final:
LOAD
  [TM ID], 
  [TM Confidential],
  Upper([TM Confidential]) as SA_TM
Resident Table1;

DROP Table1;

And then apply section access like:

Section Access;
Load * INLINE [
    ACCESS ,USER.EMAIL     ,SA_TM ,SA_PM
    USER   ,ABC@qlik.com   ,NO    ,NO
];

 You can also add a value that has all the value values related so you can use a value like ALL

Concatenate (Table1Final)
LOAD
  [TM ID], 
  [TM Confidential],
  'ALL' as SA_TM
Resident Table1Final;

Section Access;
Load * INLINE [
    ACCESS ,USER.EMAIL     ,SA_TM ,SA_PM
    ADMIN  ,Admin@qlik.com ,ALL   ,ALL
    USER   ,ABC@qlik.com   ,NO    ,NO
];

[BI_Dev]

@rubenmarin Thank you.
But I have 2 different tables with 100+ fields.

Table1:
TM ID, TM Confidential
1, Yes
2, No
3 No
];

Table2:
PM ID, PM Confidential
100, No
200, Yes
300, No
];

[Muthukumar_77]

You can try this,

TM:
Load *,Upper("TM Confidential") as TM_CONFIDENTIAL_SA_KEY Inline [
TM ID, TM Confidential
1, Yes
2, No
3 No
];

PM:
Load *,Upper("PM Confidential") as PM_CONFIDENTIAL_SA_KEY Inline [
PM ID, PM Confidential
100, No
200, Yes
300, No
];

Section Access;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, TM_CONFIDENTIAL_SA_KEY,PM_CONFIDENTIAL_SA_KEY
ADMIN, ADMIN@QLIK.COM, ADMIN123,*,*
USER, ABC@QLIK.COM, USER123, NO,NO
];

Section Application;