3 Replies Latest reply: Jun 1, 2015 11:13 AM by Andrew Whitfield RSS

    Can anyone advise why i am getting the below error.

      Syntax error, missing/misplaced FROM:

      Employee_Details:

       

       

      LOAD PERSON_ID,

           EMPLOYEE_NUMBER,

           TITLE,

           FIRST_NAME,

           LAST_NAME,

           SEX as GENDER,

           FULL_NAME As [EMPLOYEE NAME],

           Date(DATE_OF_BIRTH) as DATE_OF_BIRTH,

           EMAIL_ADDRESS,

           Date(ORIGINAL_DATE_OF_HIRE) AS JOIN_DATE,

           ORGANIZATION,

           NATIONALITY,

           MARTIAL_STATUS,

           COUNTRY_OF_BIRTH,

           AGE,

           GRADE,

           POSITION As DESIGNATION,

           DEPARTMENT as E_dept ,

       

          

          

          

          

          

      FROM

      [..\qvds\Employee_Detail.qvd]

      (qvd)

      Employee_Details:

       

       

      LOAD PERSON_ID,

           EMPLOYEE_NUMBER,

           TITLE,

           FIRST_NAME,

           LAST_NAME,

           SEX as GENDER,

           FULL_NAME As [EMPLOYEE NAME],

           Date(DATE_OF_BIRTH) as DATE_OF_BIRTH,

           EMAIL_ADDRESS,

           Date(ORIGINAL_DATE_OF_HIRE) AS JOIN_DATE,

           ORGANIZATION,

           NATIONALITY,

           MARTIAL_STATUS,

           COUNTRY_OF_BIRTH,

           AGE,

           GRADE,

           POSITION As DESIGNATION,

           DEPARTMENT as E_dept ,

       

          

          

          

          

          

      FROM

      [..\qvds\Employee_Detail.qvd]

      (qvd)