Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
puneet122016
Contributor
Contributor

Data Duplication

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

];

0 Replies