Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have module thet get the Permissions for user from SQL Tbl, i used with section access & section Application .
i have to convert my Sql tbl to Xls Tbl (load the tbl from xls) .
when i add the section access & section Application to the loadind from xls it's failed.
but if i commete it it's work fine but i must have this lines.
i copy my code:
from sql- work fine:
ODBC CONNECT TO SQL (XUserId is bbb, XPassword is yyy);
Section Access;
LOAD ACCESS,
NTNAME,
DEPT;
SQL SELECT *
FROM bbb.d.QlikviewSec;
Section Application;
LOAD DEPT,
PATH;
SQL SELECT *
FROM aaa.d.UserDept;
from Xls-not working:
SECTION Access;
LOAD [ACCESS],
NTNAME,
DEPT
FROM
C:\bbb.xls
(biff, embedded labels, table is sheet1);
SECTION Application;
LOAD DEPT,
PATH
FROM
C:\aaa.xls
(biff, embedded labels, table is sheet1)
tnx for healping!
Still not fixed? I guess something else is wrong. Could you post your QVW, or at least a limited copy (with data) that still isn't working? That would make analysis a lot easier.
Luck,
Peter