Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Syntaxis error in load script when loading from Excel sheet

Hello!

I have made an ODBC with an Excel worksheet. Qlik Sense recognises the ODBC and I can select data from the worksheet, but when I try to load the script, I get an error, saying that there is a syntaxis error in my "FROM component". The syntaxis in the FROM component looks like this:

FROM KTV_Q4_2016_SO.xlsx`.`Resultaten$` ; 

Seems okay to me. Does anyone has a clue what goes wrong here?

Thanks!

Regards,

Hugo

Tags (3)
4 Replies

Re: Syntaxis error in load script when loading from Excel sheet

Hi,

Try removing the quotes.

Regards,

Kaushik Solanki

Not applicable

Re: Syntaxis error in load script when loading from Excel sheet

Hi Kaushik,

Thank you for your suggestion! It does not work, however.

vishsaggi
Esteemed Contributor III

Re: Syntaxis error in load script when loading from Excel sheet

Try this?

FROM "Yourexcelpath\KTV_Q4_2016_SO.xlsx"."Resultaten$" ;

Chanty4u
Esteemed Contributor III

Re: Syntaxis error in load script when loading from Excel sheet

try to rename the .Xlsx file and reload again