Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some questions here, I create section access in qvw files using excel and I try to load in script, and I try to load table with same file.
And the problem is, why data always showing all data table and not same with section access login?
I want data show same with section access login, is there any settings need to set?
Thank You.
section access;
LOAD ACCESS,
USERID,
PASSWORD
FROM
[..\Sheet_access.xlsx]
(ooxml, embedded labels, table is Sheet1);
section application;
[Sheet Level]:
LOAD USERID,
Tab1,
Tab2,
Tab3,
Tab4,
Tab5
FROM
[..\Sheet_access.xlsx]
(ooxml, embedded labels, table is Sheet2);
In the Document-Settings you need to tickmark under "Opening" the fields "Initial Data Reduction...." and "Strict Exclusion".
When running the script you can see all data (ADMIN-property).
HTH Peter