Hi Again
Please see the following script, it gives me a
Table not found
TotalHoursWorked:
Left Join (FieldStaff)
LOAD
Linkedto as FieldStaffNoJoin,
ShiftLengthExMB AS TotalHoursWorked
Resident TotalHoursWorkedTable
ERROR
I'm very new to Qlikview, but need to load some data (I want to do a Sum() of the ShiftLengthExMB column, but just trying to get the concept of how to load the QVD data, join to it, and add a column from that table to my main (Fieldstaff) table.
//Load FieldStaff Table
FieldStaff:
LOAD employeenumberas [FieldStaffNoJoin],
surname as [Surname],
givennames as [GivenNames],
................................
(SysPrefix & employeenumber) as [FieldStaffNo];
SQL Select e.employeenumber,
e.surname,
e.givennames,
...............
From $(vDB2)employee E;
// Now I want to load some data from a QVD file
TotalHoursWorkedTable:
Left Join (FieldStaff)
LOAD
ShiftLengthExMB,
FieldStaffNo
FROM
(qvd);
TotalHoursWorked:
Left Join (FieldStaff)
LOAD
Linkedto as FieldStaffNoJoin,
ShiftLengthExMB AS TotalHoursWorked
Resident TotalHoursWorkedTable;
Drop Table TotalHoursWorkedTable;