Section Access Issue when access data from file

[GraceGao]

Hi Experts,

i would like to control authorization by plant in Qlik sense. i have added below script in the data model. 

However, in the excel file i can not use * to maintain all plant data. is there any way to maintain in excel file for all plant data? Thanks in advance.

---

Section Access;

AUTHORIZATION:

LOAD
"ACCESS",
"USERID",
Auth_Plant
FROM  Excel File

Section Application;

[sagarjagga]

You can keep Access and USERID column in Excel and then do a resident from excel like.
Section Access;
LOAD
"ACCESS",
"USERID",
'*' as Auth_Plant
FROM Excel File
Section Application;