Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
A couple of observations:
Other than that, I'm not quite sure what you're trying to achieve.
S.
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.