help required in section access

[ashmitp869]

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;