topic Snytax Error missing /misplaced in QlikView

Snytax Error missing /misplaced

harleen_singh — Tue, 26 Nov 2013 05:35:12 GMT

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

Re: Snytax Error missing /misplaced

jonathandienst — Tue, 26 Nov 2013 05:39:42 GMT

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

Re: Snytax Error missing /misplaced

MayilVahanan — Tue, 26 Nov 2013 05:39:42 GMT

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]

Re: Snytax Error missing /misplaced

Tue, 26 Nov 2013 05:49:27 GMT

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!

Re: Snytax Error missing /misplaced

harleen_singh — Tue, 26 Nov 2013 10:40:22 GMT

Thanks Mayil it worked

Re: Snytax Error missing /misplaced

MayilVahanan — Tue, 26 Nov 2013 10:47:51 GMT

Can you close the thread?

Re: Snytax Error missing /misplaced

harleen_singh — Mon, 02 Dec 2013 06:32:04 GMT

Mayil,

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

Re: Snytax Error missing /misplaced

Mon, 02 Dec 2013 07:00:04 GMT

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.