Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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.