topic Re: Section Access Problem in QlikView

Section Access Problem

pgalvezt — Wed, 19 Oct 2016 21:40:36 GMT

Hello,

I have this

NTNAME	ACCESS	Field1	Field2
AB	ADMIN	1	*
BC	ADMIN	2	Apple
DC	ADMIN	1	*
EF	ADMIN	1	*

In my script This:

TEMP:

LOAD

NTNAME,

ACCESS,

Field1,

Field2

FROM Table;

Concatenate(TEMP)

TEMP:

LOAD * INLINE [

NTNAME, ACCESS, Field1, Field2

"Administrador", ADMIN, *,*

"Domain\Administrador", ADMIN, *,*

];

SECTION Access;

load Distinct

upper(ACCESS) as ACCESS,

upper(NTNAME) as NTNAME,

Field1&'|'&Field2 as Authorization

RESIDENT TEMP;

SECTION Application;

DROP Table TEMP;

But I dont Have a table where I can do the same key....

Field1 comes from a different table that Field2.

And of course the data reduction not works for me.

Thanks!

Re: Section Access Problem

shawn-qv — Wed, 19 Oct 2016 22:57:35 GMT

A couple of observations:

The field Authorization (in Section Access) will need to be in uppercase
The values contained in the field Authorization (in both Section Access and Application) will need to be in uppercase
You don't have a field called Authorization in your Section Application
I would suggest loading your entire security table within Section Access
You're dropping the table TEMP twice?

Other than that, I'm not quite sure what you're trying to achieve.

Re: Section Access Problem

shraddha_g — Thu, 20 Oct 2016 06:02:17 GMT

You can keep Field1 and Field2 Separate without creating a key.

Make sure Data and Field name used within section access are Uppercase.

ex.

NTNAME	ACCESS	FIELD1	FIELD2
AB	ADMIN	1	*
BC	ADMIN	2	APPLE
DC	ADMIN	1	*
EF	ADMIN	1	*

SECTION Access;

load Distinct

upper(ACCESS) as ACCESS,

upper(NTNAME) as NTNAME,

FIELD1,

FIELD2

RESIDENT TEMP;

Section Application;

Drop table TEMP;

I hope it is helpful.