Section Access: all region not visible to admin access ?

[SunilChauhan]

Hi,

I have created a section access based on Region .

every thing is running fine but admin not able to see all region.

i mean when login with admin i.e sunil and password 1234 .it showing region field blank.

i dont know why this happening.

see the attached file.

Regards

Sunil

[SunilChauhan]

any help on this?

[hic · Accepted solution]

The reason is that you use the USERID as reducing field.Try instead using REGION as reducing field:

Section Access;

star is *;

Tab1:

LOAD upper(Access) as ACCESS,

     upper(USERID) as USERID,

     Upper(Password) as PASSWORD

     FROM test21.xlsx (ooxml, embedded labels, table is Sheet1);

Tab2:

LOAD

          Upper(USERID) as USERID,

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2);

Section Application;

Tab3:

LOAD

          Upper(Region) as REGION

          FROM test21.xlsx (ooxml, embedded labels, table is Sheet2) Where Len(Trim(Region))>1;

HIC