Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try removing the quotes.
Regards,
Kaushik Solanki
Hi Kaushik,
Thank you for your suggestion! It does not work, however.
Try this?
FROM "Yourexcelpath\KTV_Q4_2016_SO.xlsx"."Resultaten$" ;
try to rename the .Xlsx file and reload again