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

Syntaxis error in load script when loading from Excel sheet

Mon, 13 Feb 2017 15:07:59 GMT

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

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

kaushiknsolanki — Mon, 13 Feb 2017 16:33:18 GMT

Hi,

Try removing the quotes.

Regards,

Kaushik Solanki

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

Mon, 13 Feb 2017 16:50:04 GMT

Hi Kaushik,

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

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

vishsaggi — Mon, 13 Feb 2017 16:56:08 GMT

Try this?

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

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

Chanty4u — Tue, 14 Feb 2017 05:28:12 GMT

try to rename the .Xlsx file and reload again