Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to add in INTERNAL\SA_SCHEDULER and where? My section access is --
Section Access;
LOAD
'QLICKSENCESERVE\'&[USERID] AS [USERID],
Upper( [ACCESS]) as [ACCESS],
UPPER([PROJECT_ID]) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
Section Application;
LOAD
//'QLICKSENCESERVE\'& USERID AS "USERID",
UPPER(PROJECT_ID) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
and Table is--
KIndly guide.
Thanks
Tanushree Roy
Maybe just concatenate to the Section Access table:
Section Access;
LOAD
'QLICKSENCESERVE\'&[USERID] AS [USERID],
Upper( [ACCESS]) as [ACCESS],
UPPER([PROJECT_ID]) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
CONCATENATE
LOAD 'INTERNAL\SA_SCHEDULER' as USERID,
'ADMIN' as ACCESS,
'*' as PROJECT_NAME
Autogenerate 1;
'
Maybe just concatenate to the Section Access table:
Section Access;
LOAD
'QLICKSENCESERVE\'&[USERID] AS [USERID],
Upper( [ACCESS]) as [ACCESS],
UPPER([PROJECT_ID]) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
CONCATENATE
LOAD 'INTERNAL\SA_SCHEDULER' as USERID,
'ADMIN' as ACCESS,
'*' as PROJECT_NAME
Autogenerate 1;
'