Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
No matter what I try, I get the same error...
I've verified the .qvd is being created, and went so far as to:
copy the "Load" from the .qvd creation .qvw (1)
and use it in the .qvw (2) that is accessing the .qvd.
The Creation scripting:
.qvw (1)
Audit:
LOAD "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE";
SQL SELECT "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE"
FROM AXENT."HD_INCIDENT_AUDIT"
where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');
STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;
And the accessing of the .qvd (2) scripting
Audit:
LOAD "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE"
FROM
(qvd);
And the error I can not get around:
Field not found - <ACTION_DT>
Audit:
LOAD "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE"
FROM
(qvd)
Any Ideas?
Hi,
If you used the exactly same script you posted here then check the table name you give and stored in qvd?
Audit:
LOAD "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE";
SQL SELECT "ACTION_DT",
"AUDIT_ID",
"CHANGE_DT",
"ENTERED_BY",
"ENTRY_TYPE",
"IA_ACTION",
"INCIDENT_ID",
"NEW_VALUE",
"OLD_VALUE"
FROM AXENT."HD_INCIDENT_AUDIT"
where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');
STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;
May be this might be the problem.
Celambarasan
Many Thanks
I had a coworker look at the issue a day after submitting... she saw the error also.
Thanks to all that have sent a reply.