Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
FROM All_Test INTO AuditFile.qvd