Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am having field like this
company_code,company
1,company1
2,company2
3,company3
4,company4
now i want to create a group. that means all the companies
for that i created a inline table
LOAD * Inline [
company_code,company
1,company1
2,company2
3,company3
4,company4
1,group
2,group
3,group
4,group
];
now i used this company in section access
section access;
load ACCESS, USERID, Upper(Company) inline [
ACCESS, USERID, Company
USER, DOMAIN\arul.settu, Group
];
Section Application;
it is not working. can any one tell me how can i achieve this
Thanks
section access;
load ACCESS, upper(USERID) as USERID, Upper(COMPANY) as COMPANY inline [
ACCESS, USERID, COMPANY
USER, DOMAIN\arul.settu, Group
];
Section Application;
LOAD _COMP_CODE,
CurrNo,
upper(Company) as COMPANY,
Currency
FROM
(ooxml, embedded labels, table is Sheet1);
nothing happened still can see all the companies
Hi,
this worked for me:
section access;
LOAD * inline [
ACCESS, USERID,COMPANY
USER, OPD\F29121,GROUP
];
section application;
T1:
LOAD
Company_Code,
UPPER(Company) AS COMPANY
FROM [lib://Temp (opd_f29121)/Sec_test.xlsx]
(ooxml, embedded labels, table is Sheet2);
Thanks
screen shot and the excel attached:
Hi Arul,
If you want to give access to all the companies then try "*" instead of the "group"
section access;
load ACCESS, upper(USERID), Upper(COMPANY) inline [
ACCESS, USERID, COMPANY
USER, DOMAIN\arul.settu, *
];
actually i need to show a filter like this
company1
company2
company3
company4
group
one user will see company1
one user will see all company and group as well
so group is mandatory here
I have used the same data:
Thanks
Thanks both of you....
one doubt if company like this
001-company1
we nee to give this in section acces with single quotes
'001-company1' ?????
thanks
Hi Arul,
No you dont have to. Just convert it to uppercase
Thanks,
Sangram.