Dear friends,
I have an requirement from customer side
unfortunately I am not able to get final output
I am attaching sample input and what out put I need
section access is source data
roles access is created by ne as access control list
What I want here if login into application as user he want to see all programs with PMT1 by using section access
| B479_CE1_A_Line | PMT1 - Body Exterior |
| B479_CE1_2017MY | PMT1 - Body Exterior |
| B479_CE1_A_Line_T | PMT1 - Body Exterior |
script I have written here
Section Access;
LOAD UPPER(ACCESS) AS ACCESS,
UPPER(USERID) AS USERID,
UPPER(PROGRAM)&UPPER(PMT) AS AUTHORISED,
PMT ,
PROGRAM
FROM
(ooxml, embedded labels, table is Sheet4);
STAR IS *;
Section Application;
now I want to see one rmurug19 open the application he want to see all programs with pmt1
in roles access xlsx for rmurug19 in programs I want to mention star is it works?
please guide how I achieve this
