Section Access on Multiple Sheets with different data sources

[Bolijay00]

I have an application with multiple sheets and also different data sources,  on load editor each of them is loaded differently with different formulas as seen in the attached, the sheets with the same column are ok as one section access would work for them.

my question is do i perform seperate section access on the other sheets(already tried but did not work) or how do i go about it as in one of the sheets i might be performing section access with lets say field REGION but on another sheet with adifferent data source that does not even have region as a filed i want to use Department or NAME as the field to perform session Access on.

That is the road block i have, is there any one out here that could help out?

[Or]

Section Access is never based on sheets, so that part of your question is not feasible. It is based on the data contained within the tables in the data model.

Assuming the tables for each sheet are not connected at all, you can apply section access to individual tables, e.g. this should work:

Table1:
Load RowNo() as FIELD1, RowNo()*10 as Field2 Autogenerate(10);

Table2:
Load RowNo() as FIELD3 Autogenerate(10);

Section Access;

load * INLINE
[
ACCESS,USERID,GROUP, FIELD1, FIELD3
'ADMIN','MYUSER',*, 1, *
'ADMIN','MYUSER',*, *, 3
];

If the tables are connected, you would need to apply the appropriate section access to reduce the data to the required combinations.