Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rubinsky
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

STORING TO QVD FILE

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.

3 Replies
Not applicable

STORING TO QVD FILE

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
New Contributor II

STORING TO QVD FILE

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

-jdr

Not applicable

STORING TO QVD FILE

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.

Community Browser