Create section access

[ddyt]

Hey,

I need to Create section access based on department name and all the employee levels.

     Example: Employee Shelli Baida needs to see two departments (RnD, HR).

anyone any suggestions? I think maybe first creating crosstable and then section access..

departmen_name	primary_owner	additional_view1	additional_view2	additional_view3
IoT	Steven King	Neena Kochhar	Diana Lorentz	Sarah Bell
Security	Alexander Hunold
Products	David Austin	Lex De Haan	Neena Kochhar
RnD	Alexander Hunold	Bruce Ernst	Shelli Baida	Diana Lorentz
Sales	Steven King
Operation	David Austin	Ellen Abel
HR	Steven King	Amit Banda	Shelli Baida	Hermann Baer

[Or]

If it's just these three, you could load them in four passes:

Load departmen_name, primary_owner as USER

JOIN

Load departmen_name, additional_view1 as USER

etc.

If there's a larger number of potential addtional_view, then yes, you'll need to get this into a standard table rather than a crosstable, and then use that.