STORING TO QVD FILE

[rubinsky]

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

[#2 · Accepted solution]

your statement should rather be:

Data:

Account,OSUser() AS user,ComputerName() AS workstation,Now() AS auditdatetime
FROM All_Test;

STORE * from Data into AuditLog.qvd;

you may also wish to mention the path in the STORE statement and the path of All_Test after the FROM clause.

[rubinsky]

Thank you!  If I try and do this multiple times will the data just append or just overwrite?

-jdr

[#4]

It'll get overwritten everytime unless you do an incremental load which allows you to put some constraints (like date/timestamps) in which case you can acheive appending data.