0 Replies Latest reply: Oct 25, 2012 10:46 PM by Don Green RSS

    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
      [D:\QV Development\ShiftsData.qvd]
      (qvd);

      TotalHoursWorked:
      Left Join  (FieldStaff)
      LOAD   
         Linkedto as FieldStaffNoJoin,
         ShiftLengthExMB AS TotalHoursWorked
      Resident TotalHoursWorkedTable;
      Drop Table  TotalHoursWorkedTable;