Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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
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]
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!
Thanks Mayil it worked
Hi
Can you close the thread?
Mayil,
i don't see any option of closing thread here. This new forum is really tough to understand can u help me?
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.