Hello,
Are you trying exactly with the script you sent above?
If yes, there are a few issues with it.
1. You need ACCESS field specified.
2. In order to filter the users, you need USERID or GROUP field.
3. In order to star to work, you need all values already listed in REDUCTION field inside of Section Access block. STAR IS value list is composed of only the values listed in the section access area; it does not check the original list of values in data.
Code below works fine.
Sample USERID Value: 'DOMAIN\USER';
ACCESS field value: ADMIN or USER
//Code Starts here
section access;
LOAD
"ACCESS",
"USERID",
REDUCTION
FROM [lib://Desktop/test.xlsx]
(ooxml, embedded labels, table is Sheet1);
star is '*';
section application;
TEST:
LOAD
REDUCTION,
VALUE
FROM [lib://Desktop/test.xlsx]
(ooxml, embedded labels, table is Sheet2);
//Code ends here
BR
Serhan
