loading data base on user

[#1]

I have a excel sheet which I loaded. If the value for user is 1, I will load the data for that.

First I load the excel control assess sheet as shown below

AccessControl:
LOAD UserID,
ENTITY,
VALUE
FROM
Access.xlsx
(ooxml, embedded labels, table is Sheet1);

Then i load the real data which contains entities like SIN, CN, AA and CN.

LOAD M_ENTITY, 

FROM
[Data\LNBR_2016-09-30.xlsx]
(ooxml, embedded labels, table is DATA);

I use LET userID = QVUser(); to get the UserID which corresponds to the UserID in the excel sheet. For example, A9900899. Since A9900899 on the excel sheet has values 1 for SIN, CN and AA, i will load these data from the real data. But if the user who uses this application has UserID A1234567, only AA will be loaded.

How can I do this? Thanks

[vinieme12]

please post sample data for both tables

[vinieme12]

or read this

http://www.axisgroup.com/optimized-qvd-loads-caveats-for-using-the-exists-function/