Load table without applying Section Acess

[Anonymous]

I am trying to implement Section Access

SECTION ACCESS;

LOAD * INLINE [ 

ACCESS, USERID, EMPLOYEEID,OMIT

ADMIN, ADMIN 

USER, UK, 4,ShipRegion

USER, USA, 1,Shipregion

USER, USA, 3,Shipregion

USER, USA, 2,Shipregion 

]; 

SECTION APPLICATION; 

OLEDB CONNECT TO [SQL Connection String]);

SQL SELECT [OrderID]

      ,[CustomerID]

      ,[OrderDate]

      ,[EmployeeID] AS EMPLOYEEID

      ,[RequiredDate]

      ,[ShippedDate]

      ,[ShipVia]

      ,[Freight]

      ,[ShipName]

      ,[ShipAddress]

      ,[ShipCity]

      ,[ShipRegion]

      ,[ShipPostalCode]

      ,UPPER([ShipCountry]) AS REGION

FROM Orders;

SQL SELECT EMPLOYEEID,EMPNAME FROM

FROM Employee;

For Employee table also it is applying Section Access. Is there any way that no Section Access is applied to Employee table (means to load complete Employee table irrespective of Section Access)

[devarasu07]

Hi,

we can't exclude table from section access. may be you can check this below advise

Exclude a table from section access | Qlik Community

[Anonymous]

How to create data Island from sql server.

Also, can I use the data Island create in above step for view and without applying section access on data Island

[Miguel_Angel_Baeyens]

Basically you need to add all possible values in the key field for the table and the table will not be reduced, schematically something like this:

SECTION ACCESS;

SectionAccessTable:
LOAD DISTINCT
  'ADMIN' AS ACCESS,
  'DIR\ADMIN' AS NTNAME,
  COUNTRY,
  '*' AS EMPID
FROM Invoices.qvd (qvd);

CONCATENATE (SectionAccessTable)
LOAD DISTINCT
  'ADMIN' AS ACCESS,
  'DIR\ADMIN' AS NTNAME,
  '*' AS COUNTRY,
  EMPID
FROM Employees.qvd (qvd);

CONCATENATE (SectionAccessTable)
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY, EMPID
USER, DIR\USERSPAIN, SPAIN, *
USER, DIR\USERFRANCE, FRANCE, *
];

SECTION APPLICATION;

Invoices:
LOAD
  INVOICEID,
  COUNTRY,
  AMOUNT
FROM Invoices.qvd (qvd);

Employees:
LOAD
  EMPID,
  EMPNAME
FROM Employees.qvd (qvd);