Section access help

[Krish2459_58]

Hi, I'm trying to implement section access with th eblow code but not able to authorize data based on user login.

Could you please help to identify what went wrong.

ACCESS	USERID	Group
ADMIN	NA\SVC_QS_SYSTEMPROD	*
ADMIN	NA\SVC_QLIKVIEWDEVTEST	*
ADMIN	NA\SVC_QS_SYSTEMDEV2	*
ADMIN	INTERNAL\SA_REPOSITORY	*
ADMIN	INTERNAL\SA_SCHEDULER	*
USER	*	*
USER	LKNDZ\REDDYK	BCC
USER	EXCELODBCUDC\KEELAN@xyz.COM	BCCINVST

SECTION ACCESS;
Security:
LOAD
"ACCESS",
"USERID",
"Group"
FROM [/Security.xlsx]
(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

Groupref:
load * inline [
Group
BCC
BCCINVST
];

[sbaro_bd]

Hi @Krish2459_58 ,

Before to load your security table, declare the star symbole like a string.

STAR IS *;

SECTION ACCESS;
Security:
LOAD
"ACCESS",
"USERID",
"Group"
FROM [/Security.xlsx]
(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

Groupref:
load * inline [
Group
BCC
BCCINVST
];

Regards.

[Muthukumar_77]

Hi,

Field "Group" & value should be uppercase. 

SECTION ACCESS;
Security:
LOAD
"ACCESS",
"USERID",
Upper("Group") as GROUP
FROM [/Security.xlsx]
(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

Groupref:
load * inline [
GROUP
BCC
BCCINVST
];