Discussion board where members can get started with QlikView.
Please see the following script, it gives me a
Table not found
Left Join (FieldStaff)
Linkedto as FieldStaffNoJoin,
ShiftLengthExMB AS TotalHoursWorked
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
Left Join (FieldStaff)LOAD ShiftLengthExMB, FieldStaffNoFROM(qvd);
TotalHoursWorked:Left Join (FieldStaff)LOAD Linkedto as FieldStaffNoJoin, ShiftLengthExMB AS TotalHoursWorkedResident TotalHoursWorkedTable;Drop Table TotalHoursWorkedTable;