Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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