Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to add INTERNAL\SA_SCHEDULER in table with section access?

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--

sectionaccess Table.PNG

KIndly guide.

Thanks

Tanushree Roy

1 Solution

Accepted Solutions
MVP
MVP

Re: How to add INTERNAL\SA_SCHEDULER in table with section access?

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;

     '

2 Replies
MVP
MVP

Re: How to add INTERNAL\SA_SCHEDULER in table with section access?

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;

     '

Not applicable

Re: How to add INTERNAL\SA_SCHEDULER in table with section access?

Hi

swuehl

Its working for me..

Thanks a lot.


Thanks

Tanushree Roy