Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Syntax error, Table Not Found

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;

Community Browser