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
