Hi there,
table1:
LOAD DISTINCT
NTNAME,
ACCESS,
ACCESSDETAIL
RESIDENT UserList;
Table2:
Load distinct SecuredOrgAccessAttribute,[Ward/Location] resident WardwithFlag
where securorgatt <> 1
I want in the third table3 , like
ANY Other clinics
LOAD DISINCT NTNAME,Organisation as SecuredOrgAccessAttribute
where securorgatt <> 1;
I am unable to fetch the NTNAME other clinics .
Showing null -