help required in section access

ashmitp869 — Fri, 17 Jun 2022 00:00:17 GMT

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;

topic help required in section access in QlikView

help required in section access