Section acees with mutilpe fields

krishna20 — Thu, 09 Jun 2016 07:03:53 GMT

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

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

Re: Section acees with mutilpe fields

krishna20 — Thu, 09 Jun 2016 07:11:45 GMT

sorry if my sentences is not understand

krishna20 — Thu, 09 Jun 2016 07:19:38 GMT

The objective of this task is

other than admin can I use star for program