Can anyone advise why i am getting the below error.

[#1]

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)

[maxgro]

remove

,

before from (here DEPARTMENT as E_dept ,)

[Colin-Albert]

The last line of the data should not have a comma at the end of the line

DEPARTMENT as E_dept ,

FROM [..\qvds\Employee_Detail.qvd] (qvd)

try

DEPARTMENT as E_dept

FROM [..\qvds\Employee_Detail.qvd] (qvd)

[awhitfield]

Hi Tariq,

you don't need the , (Comma) at the end of the 2 lines:

     DEPARTMENT as E_dept ,

Andy