Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
sharun
Contributor
Contributor

Section Access not working

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;

0 Replies