topic STORING TO QVD FILE in QlikView

STORING TO QVD FILE

rubinsky — Tue, 01 Nov 2011 17:36:39 GMT

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

STORING TO QVD FILE

Tue, 01 Nov 2011 17:42:07 GMT

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.

STORING TO QVD FILE

rubinsky — Tue, 01 Nov 2011 17:53:31 GMT

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

-jdr

STORING TO QVD FILE

Tue, 01 Nov 2011 17:56:06 GMT

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.