Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
any help on this?
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