LOAD syntax

[funkle]

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

[lblumenfeld · Accepted solution]

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);

[Gysbert_Wassenaar]

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.