1 Reply Latest reply: Aug 10, 2014 2:05 AM by Manish Kachhia RSS

    Table Not Found when using left join

    Jerome Jackson

      Tab1

       

      $(qvd_name)

       

      : Load

      [ID Number] ,
      [Department Name]

      from  

      QVD\Layer 2\T_Department.qvd](

      qvd)

       

      Tab 2

      left join

      NoConcatenate
      [table 2]

      LOAD
      [ID Number] ,
      [Hiire Date]
      FROM
      [S:\Data\QVD\Layer 2\T_Employment.qvd](
      qvd)

      Where [Hire Date] >0;

       

      [Employee Rec]

      Load

      [ID Number],

      max(Hire Date]) as [Date Hire]

      Resident

       

       

      [table 3]:]:
      load
      [ID Number] ,
      max(s483_Dt) as [483 Dt],
      max(s324_Dt) as [324 Dt],
      max(s367_Dt) as [367 Dt]
      Resident  [tabe 2]
      Group by [ID Number];

      drop Table [table 2];

       

       

      STORE

      $(qvd_name)  into $(qvd_layer_3_path) $(qvd_name).qvd (qvd);

       

      In this example table 1 is the source table.  Table 2 has a common field called ID