Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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;

     '

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Author

Hi

swuehl

Its working for me..

Thanks a lot.


Thanks

Tanushree Roy