Discussion Board for collaboration on QlikView Security and Governance.
How can I Export Section Access Table to a qvd?
Go to Solution.
Following works for me:
Create Tmp Table with Section Access Information.
Export table as QVD(!) and reload the QVD with "where 1=1"
LOAD * INLINE [ ACCESS, USERID, PASSWORD, NTNAME
ADMIN, admin, 1234, * USER, user, , *
USER, test, test, MS\SCOTT];
tmp_SectionAccess into TmpSectionAccess.qvd (qvd);
drop Table tmp_SectionAccess ;
SECTION Access; LOAD ACCESS, USERID, PASSWORD, NTNAME FROMTmp_SectionAccess.qvd (qvd)WHERE 1=1;
Couldn't you simply use:
store SectionAccess into SectionAccess.qvd (qvd);
was not successful.