Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rubinsky
Contributor II
Contributor II

Field not found during STORE statement

Hi Folks, I'm trying the following and I'm not having much luck.  Thank you.

LOAD VisitID,

    Location,

    Room,

    Bed,

    Room & '-' & Bed as RoomBed,

    Account,

    Patient,

    reasonforvisit,

    AdmissionDiagnosis,

    AttendPhysician,

    AdmitDateTime,

    los,

/*    UpdateDate, */

    OrderSetUsed,

    VTEProphMeds,

    VTEMedsContra,

    Device,

    SurgeryDateTime,

    SurgVTEProphMeds,

    SurgVTEMedsContra,

    SurgDevice,

    PNVaccineEligible,

    PNVaccineGiven,

    FluVaccineEligible,

    FluVaccineGiven,

    OSUser() AS audituser,

    ComputerName() AS auditworkstation,   

    Now() AS auditdatetime;

SQL SELECT *

FROM Tim.dbo."All_Test";

STORE Account, audituser, auditworkstation, auditdatetime, auditreport

FROM All_Test INTO AuditFile.qvd;

Results in

Field not found

STORE Account, audituser, auditworkstation, auditdatetime, auditreport

FROM All_Test INTO AuditFile.qvd

0 Replies