Section Access not working

sharun — Wed, 20 Feb 2019 11:41:43 GMT

I am working on section access and created below code. It is not working. Please help

section access;
Star is *;

AccessTable:
LOAD
ACCESS,
USERID,
if(Len(Trim(BRANCH_GROUP))=0,'*',BRANCH_GROUP) as BRANCH_GROUP
FROM [$(vPath)/UserAccess.xlsx](ooxml, embedded labels, table is UserAccess);

Left Join(AccessTable)

LOAD
BRANCH_GROUP,
AGENTCODE as BRANCHKEY
FROM [$(vPath)/UserAccess.xlsx](ooxml, embedded labels, table is BranchGroup);

AccessTable_Final:
Load
ACCESS,
USERID,
if(Len(Trim(BRANCH_GROUP))=0,'*',BRANCH_GROUP) as BRANCH_GROUP,
if(Len(Trim(BRANCHKEY))=0,'*',BRANCHKEY) as BRANCHKEY
Resident AccessTable;

Drop Table AccessTable;

section application;

topic Section Access not working in App Development

Section Access not working