section access from excel file

[Meg00]

Hello everyone!

I haven't had that much experience with section access and would be thankful for some help.

The end user app has dimension Region with values "North", "Central", "South" and "Others".

My access file looks as below, my aim is to create a clean QVD to load into the end user app. Do I have to repeat rows for users with more than one region? What is the best way of doing this?

Name	AD acc	North	Central	South	Others
name1	acc1	yes
name2	acc2			yes
name3	acc3		yes
name4	acc4	yes	yes	yes	yes
name5	acc5	yes	yes	yes	yes
name6	acc6	yes	yes	yes	yes
name7	acc7	yes	yes	yes	yes
name8	acc8	yes	yes	yes	yes
name9	acc9	yes	yes	yes	yes
name10	acc10	yes	yes	yes	yes
name11	acc11	yes	yes	yes	yes
QlikView Admin account	local\qvadmin	yes	yes	yes	yes

[QFabian]

hi, here attached you have an example of excel file for section access.

This is the script :

Section Access;

LOAD
ACCESS,
NTNAME,
[USERID],
[PASSWORD],
GROUP,
[PROFILE]
FROM [seguridad.xls] (biff, embedded labels, table is Access$);

Section Application;
star is *;

Grupos:
LOAD
GROUP,
Zona
FROM [seguridad.xls] (biff, embedded labels, table is Aplication$);

[Meg00]

Thank you,

but I can not change how the excel file looks. 

managed to get a clean table with crosstable function.

The only question remaining is, will it work is the same user has multiple rows in the table when that user should have access to all Regions?