Data Duplication

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have tried the following link de-identify data for certain users

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

];

topic Data Duplication in QlikView