1 Reply Latest reply: Jul 20, 2012 2:57 PM by mayilvahanan ramasamy RSS

    Need to help for Max date error

      
      

       

      I got this error message from reload my script

       

      invalid expression

      EmplHist:

      LOAD EMPL_ID,

        FULL_NAME,

        Status,

        HOME_ORG_ID,

        TITLE_DESC,

        GLC,

        DATE(max([EMP_END_DATE]))

       

      RESIDENT TempEmployeeHist

      WHERE EXISTS (DirectOrg, HOME_ORG_ID)

       

       

      =================================

       

      TempEmployeeHist:
      LOAD   EMPL_ID,
          LAST_NAME & ', '& FIRST_NAME as [FULL_NAME],
          S_EMPL_STATUS_CD as Status;
         
      SQL SELECT *
      FROM $(vSchemaOwner).EMPL;

      LEFT JOIN (TempEmployeeHist)
      LOAD   EMPL_ID,
          ORG_ID as [HOME_ORG_ID],
          TITLE_DESC,
          GENL_LAB_CAT_CD as [GLC],
          DATE(END_DT) as [EMP_END_DATE];
      SQL SELECT *
      FROM $(vSchemaOwner).EMPL_LAB_INFO;


      //***********************
      EmplHist:
      LOAD EMPL_ID,
        FULL_NAME,
        Status,
        HOME_ORG_ID,
        TITLE_DESC,
        GLC,
        DATE(max([EMP_END_DATE]))
       
      RESIDENT TempEmployeeHist
      WHERE EXISTS (DirectOrg, HOME_ORG_ID);

      //DROP TABLE TempEmployeeHist;