Section Access Problem

[pgalvezt]

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!

[shawn-qv]

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.

S.

[shraddha_g]

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.