Section access and resident load

[jleberre]

Hello

I'm trying to perform data reduction. The security table, in the section access, load the data from a previously loaded table. But it locks my account. Using an inline table, it works.

I don't understand... Can someone help me?

My code:

// Data reduction

Input:
NoConcatenate
Load * Inline [
Access,Server,User,Country
ADMIN,QLIK,jleberre,FR
];

access:
NoConcatenate
Load
Access as ACCESS,
Server&'\'&User as USERID,
Country as REDUCTION,
'' as OMIT
Resident Input;

Drop Table Input;

Section Access;

Load
ACCESS,
USERID,
REDUCTION,
OMIT
Resident access;

// LOAD * Inline [
// ACCESS,USERID,REDUCTION,OMIT
// ADMIN,INTERNAL\SA_SCHEDULER,*,*,
// ADMIN,QLIK\jleberre,FR,
// ];

Section Application;

Drop Table access;

// Data model

Country:
NoConcatenate
Load * Inline [
Country,REDUCTION
France, FR
UnitedStates, US
];

Sales:
NoConcatenate
Load * Inline [
Product,Country,Sales
sweeat,France,10
sweat,UnitedStates,30
tshirt,France,20
tshirt,UnitedStates,60
jeans,France,30
jeans,UnitedStates,40
];

Thanks!

[saar_lorena · Accepted solution]

Hi, Try to apply an UPPER() on userID.

[OmarBenSalem]

every field used in a section access MUST be in UPPER case

[jleberre]

Ok thank you!