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;