Data Duplication

[Anonymous]

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

];