Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harleen_singh
Creator III
Creator III

Snytax Error missing /misplaced

I am fetching the data from Excel sheet and i get following Error. I don't know is there is any problem with column names?



Syntax error, missing/misplaced FROM:

LOAD [# of Recordable Medical Treatment (no lost workday)   [A1]]] as [KPI 1],

     [# of Restricted Work Activity Cases (no lost workday)  [B1]]] as [KPI 2]

thanks

Lavi

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

LOAD "# of Recordable Medical Treatment (no lost workday)   [A1]" as [KPI 1],

     "# of Restricted Work Activity Cases (no lost workday)  [B1]" as [KPI 2]

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

7 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Lavi

As the error message says, you have not included a FROM statement:

LOAD [# of Recordable Medical Treatment (no lost workday)   [A1]]] as [KPI 1],

     [# of Restricted Work Activity Cases (no lost workday)  [B1]]] as [KPI 2]

FROM myExcelWOrksheet.xlsx (ooxml, ....)


I assume that [# of Recordable Medical Treatment (no lost workday)   [A1]]] is a column in your spreadsheet.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MayilVahanan

Hi

Try like this

LOAD "# of Recordable Medical Treatment (no lost workday)   [A1]" as [KPI 1],

     "# of Restricted Work Activity Cases (no lost workday)  [B1]" as [KPI 2]

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable

Hi Lavi,

Two points:

1. In your field names, one  ']' is extra after A1 and B1, it should be:

     LOAD

     [# of Recordable Medical Treatment (no lost workday)   [A1]] as [KPI 1],

     [# of Restricted Work Activity Cases (no lost workday)  [B1]] as [KPI 2]

2. "From" is missing in your statement, after

LOAD

----

----

From (Name of the excel file from where you are pulling the data)

Hope this helps!

harleen_singh
Creator III
Creator III
Author

Thanks Mayil it worked

MayilVahanan

Hi

Can you close the thread?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
harleen_singh
Creator III
Creator III
Author

Mayil,

            i don't see any option of closing thread here. This new forum is really tough to understand can u help me?

Not applicable

Below every answer, you will get an option to mark that answer as correct or helpful. Once you do that the thread will be marked Answered.