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;