3 Replies Latest reply: Nov 1, 2011 1:56 PM by Jasleen Puri RSS

    STORING TO QVD FILE

      I'm trying to capture the user name, workstation, and datetime of the user running Qlikview and attaching it to every row returned in the table "All_Test".  Then taking those results and putting them into a QVD file (AuditLog.qvd).  However it's not working.  I would be greatful for any help.  Thank you,

       

      -jdr

       

      STORE All_Test.Account,OSUser() AS user,ComputerName() AS workstation,Now() AS auditdatetime
      FROM
      All_Test INTO AuditLog.qvd;

       

      Syntax error, missing/misplaced FROM:
      STORE All_Test.Account,
            OSUser() AS user,
            ComputerName() AS workstation,
            Now() AS auditdatetime
      FROM All_Test INTO AuditLog.qvd
      STORE All_Test.Account,
            OSUser() AS user,
            ComputerName() AS workstation,
            Now() AS auditdatetime
      FROM All_Test INTO AuditLog.qvd