Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you! If I try and do this multiple times will the data just append or just overwrite?
-jdr
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.