Hi there,
If anyone can help me with the section access.
I have to implement this logic like marked in bold
Section Access;
NTNAME,ACCESS,SecuredOrgAccessAttribute
1, USER, CPCS&SAS
1, USER, SAS
-- ANY Other clinics
LOAD DISINCT NTNAME,Organisation as SecuredOrgAccessAttribute
where securorgatt <> 1;
Section Application;
Data model -
I tried this script -
UserCustomerAccess:
LOAD DISTINCT
NTNAME,
ACCESS,
ACCESSDETAIL,
ACCESSDETAIL as SecuredOrgAccessAttribute
RESIDENT UserList;
right join (UserCustomerAccess)
Load distinct SecuredOrgAccessAttribute,[Ward/Location] resident WardwithFlag
where securorgatt <> 1
;
Final:
LOAD DISTINCT
NTNAME,
ACCESS,
ACCESSDETAIL,
ACCESSDETAIL as SecuredOrgAccessAttribute
RESIDENT UserList;
Concatenate(Final)
Load
NTNAME,
ACCESS,
ACCESSDETAIL,
[Ward/Location] as SecuredOrgAccessAttribute
Resident UserCustomerAccess;
Drop table UserCustomerAccess;