How to add two values in reduction section while applying row level security ?

[Anonymous]

HI ,

now suppose I want to assign 2 values to one user id , for eg

Section Access;

LOAD * INLINE [

ACCESS, USERID, HOSPITAL

ADMIN,QLIK-SENSE\Admin,*

USER,QLIK-SENSE\xxx,ABC

USER,QLIK-SENSE\yyy,DEF

USER,QLIK-SENSE\zzz,GHI

If I want to assign both  (GHI and JKL) hospital value  to user zzz

How to write in script level ?

[devyanshu_gupta · Accepted solution]

Hi,

You can add another line with value JKL

Try this

LOAD * INLINE [

ACCESS, USERID, HOSPITAL

ADMIN,QLIK-SENSE\Admin,*

USER,QLIK-SENSE\xxx,ABC

USER,QLIK-SENSE\yyy,DEF

USER,QLIK-SENSE\zzz,GHI

USER,QLIK-SENSE\zzz,JKL

]

Regards,

Devyanshu