Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

zhadrakas
Valued Contributor

OMIT Problem

Hello,

i have encountered a weird behavior in Section Access with OMIT field.

Im using QlikView 11.

Document Settings:

Szenario 1) Script)

OMITgroup in Inline Table: This works fine

Section Access;

OMITGROUP:
Load * inline [
OMITGROUP, OMIT
Group1, Field1
Group1, Field2
Group1, Field3
Group1, Field4
]
;

OMIT:
load * inline [
ACCESS, NTNAME, OMITGROUP
ADMIN, DOMAIN\USER, 
USER, DOMAIN\USER1, Group1
]
;

Section Application;
Star is *;

Szenario 1) Ouput)

works as expected. Fields are not available

Szenario 2)

Add Users with Omitgroup via concatenate Load. This doesn't work

Section Access;

OMITGROUP:
Load * inline [
OMITGROUP, OMIT
Group1, Field1
Group1, Field2
Group1, Field3
Group1, Field4
]
;

OMIT:
load * inline [
ACCESS, NTNAME, OMITGROUP
ADMIN, DOMAIN\USER, 
]
;

Concatenate (OMIT)
LOAD 'USER' as ACCESS,
'DOMAIN\USER1' as NTNAME,
'Group1' as OMITGROUP
  
AutoGenerate (1);

Section Application;
Star is *;

Szenario 2) Output)

Omit doesnt work

Can anyone explain me why this happens?

Regards

tim

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: OMIT Problem

In my experience qv doesn't seem to like the SA table to be created in more than one part (the concatenation). If you need to because you have e.g. different sources then create that table outside of the SA part first and store it in e.g. a qvd. Then in SA load that qvd in one go.

3 Replies
michael123
Contributor

Re: OMIT Problem

I get exactly the same result as you in scenario 1 when copying your scenario 2 into a load script.

QV 11.2 SR9.

/Michael

stigchel
Honored Contributor

Re: OMIT Problem

In my experience qv doesn't seem to like the SA table to be created in more than one part (the concatenation). If you need to because you have e.g. different sources then create that table outside of the SA part first and store it in e.g. a qvd. Then in SA load that qvd in one go.

zhadrakas
Valued Contributor

Re: OMIT Problem

Thank you for your answers.

I have tested a lot:.

Both Szenarios are working fine if all instances of omitgroup are in uppercase.

But i think its Still better to source that part out and load it resident in section Access.

Community Browser