Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
can some one help me how to make my static NTName section access to Dynamic section access. kindly help me to modify static code to dynamic.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
USER, NAEAST\U10320
USER, NAEAST\U40733
USER, NAEAST\U49612
USER, NAEAST\U50477
ADMIN, NAEAST\T01165
];
Section Application;
LOAD * INLINE [
NTNAME, SID
NAEAST\U10320,U10320
NAEAST\U40733,U40733
NAEAST\U49612,U49612
NAEAST\U50477,U50477
NAEAST\T01165,T01165
];
Regards,
Navin
What do you expect us to do?
Do you even understand what have you asked?
Sorry for being harsh, but you should know how to ask the questions, isn't it?
I request you to provide as much detail as you can about your issue. Use an example to make us understand it. If possible provide the sample data and expected output from that data.
@kaushiknsolanki sorry for my bad explanation.
i have used below script for build the NTNAME section access, if any updates in future i have to update section access manually. To avoid manual edits,how can i build script based on data changes.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
USER, NAEAST\U10320
USER, NAEAST\U40733
USER, NAEAST\U49612
USER, NAEAST\U50477
ADMIN, NAEAST\T01165
];
Section Application;
LOAD * INLINE [
NTNAME, SID
NAEAST\U10320,U10320
NAEAST\U40733,U40733
NAEAST\U49612,U49612
NAEAST\U50477,U50477
NAEAST\T01165,T01165
];
Regards,
Navin
@kaushiknsolanki with the below script, i have build the dynamic section access. now i have added my name to the excel data list. when im trying to open the application i got the " Access Denied" error message. kindly help in future any additions to the list how can i provide the access to the members. kindly help me
Data:
LOAD Source,
SID
FROM
[..\Desktop\Section Access\Output.xlsx]
(ooxml, embedded labels, table is Sheet1);
USERACCESS:
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,
];
Concatenate
LOAD 'USER' AS ACCESS,
'NAEAST\'& SID as NTNAME
RESIDENT Data;
Drop table Data;
Section access;
Load *
Resident USERACCESS;
Section application;
Regards,
Navin
Its because you missed the reduction field.
Your section access should have 3 fields.
1. Access
2. NTName
3.ReductionField. (The field on which you want to restrict the access).
@kaushiknsolanki Thanks for your reply,
Based on SID im restricting the access, could you please suggest me where should i include the SID on script. kindly help me.
You should replace NTNAME with NTSID Field.
And this field should contain your SID.
@kaushiknsolanki sorry for my later reply, still i am unable to figure out the section access issue. kindly help me. i am attaching the section access script and excel file.
Data:
LOAD Source,
[Review ID],
[Control name],
[Trade Date],
SID,
'NAEAST\'& SID as NTNAME,
[Reviewee Name]
FROM
[..\Desktop\Section Access\Output.xlsx]
(ooxml, embedded labels, table is Sheet1);
USERACCESS:
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,
];
Concatenate
LOAD 'USER' AS ACCESS,
NTNAME
RESIDENT Data;
/* remove data members from memory */
Drop table Data;
/* create section access */
Section access;
Load *
Resident USERACCESS;
Section application;
Dear NavinReddy,
I told you in my above post that your section access table should have 3 columns.
But in your script, I can see only 2 columns, i.e Access and NTName
Also for Admin, you have not defined the NTNAME in your table.
Due to this both things your script is not working as desired.
Correct them and it will work.
For more help look at the link below.
Adding one additional Design Blog post for some additional information:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
Regards,
Brett