Syntax error, Table Not Found

Fri, 26 Oct 2012 02:46:37 GMT

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;

topic Syntax error, Table Not Found in QlikView

Syntax error, Table Not Found