Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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)

3 Replies
MVP
MVP

Re: Can anyone advise why i am getting the below error.

remove

,

before from (here DEPARTMENT as E_dept ,)

Re: Can anyone advise why i am getting the below error.

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
Esteemed Contributor

Re: Can anyone advise why i am getting the below error.

Hi Tariq,

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

     DEPARTMENT as E_dept ,

Andy