I have tried the following link de-identify data for certain users
https://community.qlik.com/docs/DOC-18235
Mask or de-identify data for certain users using Section Access
But when I add the extra school for the user then the data gets duplicated for that user.
eg I have added the following lines
1. userA,SchoolD
2. SchoolD,Philp_1,Andrew_1,Maths_1,77
for eg:
Load * Inline
[
USERID,School
userA,SchoolA
userB,SchoolB
userA,SchoolD
userC,<ANY>
];
Result:
LOAD * Inline
[
School,Teacher,Student,Subject,Result
SchoolA,Anne,Peter,History,80
SchoolB,Simon,Jhon,Maths,70
SchoolC,Tony,Paul,History,58
SchoolA,Stuart,Mathew,Maths,90
SchoolB,Chris,Kai,Science,82
SchoolC,Philp,Andrew,Maths,66
SchoolD,Philp_1,Andrew_1,Maths_1,77
];