Snytax Error missing /misplaced

[harleen_singh]

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

[jonathandienst]

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

[MayilVahanan · Accepted solution]

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]

[#4]

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]

Thanks Mayil it worked

[MayilVahanan]

Hi

Can you close the thread?

[harleen_singh]

Mayil,

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

[#8]

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.