Why doesn't this load? (Qlik Sense Section access)

trappersw — Tue, 23 Feb 2016 13:49:51 GMT

Why doesn't this load in Qlik Sense server (it loads withing 20" when the section access and section application are commented)

Section access;

Security:

load *;

SQL SELECT distinct

'USER' as 'ACCESS',

upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

union all

SELECT distinct

'USER' as 'ACCESS',

upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

where isnumeric(substring([user_id],5,100))=0 and

substring([user_id],5,100) like '%.%';

Concatenate

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER, *

];

Section application;

Securityapp:

load *;

SQL SELECT

[KEY_AD_GROUP] as REDUCTION,

key_business+'_'+key_market as BusinessMarket

FROM [WH_ID_EMEA].[cfg].[AD_Access];

Re: Why doesn't this load? (Qlik Sense Section access)

Gysbert_Wassenaar — Tue, 23 Feb 2016 16:52:23 GMT

Have you tried it this way?

Security:

SQL SELECT distinct

'USER' as 'ACCESS',

upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

union all

SELECT distinct

'USER' as 'ACCESS',

upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

where isnumeric(substring([user_id],5,100))=0 and

substring([user_id],5,100) like '%.%';

CONCATENATE (Security)

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER, *

];

Section access;

LOAD * RESIDENT Security;

Section Application;

...etc

topic Re: Why doesn't this load? (Qlik Sense Section access) in App Development

Why doesn't this load? (Qlik Sense Section access)

Re: Why doesn't this load? (Qlik Sense Section access)