topic LOAD syntax in QlikView

LOAD syntax

funkle — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Does anyone have any idea about the "correct" syntax in regards to loading from Excel files, I found the file name can be either in different forms:

1. Enclosed in square brackets

2. Enclosed in single/double quotation

3. No quotation or brackets at all

Either of the above works but I am just confused if there is such a "Correct" way.

Cheers

Re: LOAD syntax

lblumenfeld — Sun, 18 Nov 2018 07:33:20 GMT

I've always used this syntax with the brackets. It accommodates all different types of file names, even ones with spaces. It's also the one that the data manager will use.

FROM [lib://dirname/filename.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: LOAD syntax

Gysbert_Wassenaar — Sun, 18 Nov 2018 08:01:31 GMT

Perhaps this blog post helps explain things a bit:
https://community.qlik.com/t5/Qlik-Design-Blog/QlikView-Quoteology/ba-p/1476029

With regards to file names in load statements I second Lblumenfelds recommendation. Always use square brackets. That will always work no matter what characters the file name contains.