The Directory statement defines which directory to look in for data files in subsequent LOAD statements, until a new Directory statement is made.
Syntax:
Directory[path]
If the Directory statement is issued without a path or left out, Qlik Sense will look in the Qlik Sense working directory.
Arguments:
| Argument | Description |
|---|---|
| path |
A text that can be interpreted as the path to the data file. The path is the path to the file, either:
|
Examples:
DIRECTORY C:\userfiles\data; // OR -> DIRECTORY data\
LOAD * FROM
[data1.csv] // ONLY THE FILE NAME CAN BE SPECIFIED HERE (WITHOUT THE FULL PATH)
(ansi, txt, delimiter is ',', embedded labels);
LOAD * FROM
[data2.txt] // ONLY THE FILE NAME CAN BE SPECIFIED HERE UNTIL A NEW DIRECTORY STATEMENT IS MADE
(ansi, txt, delimiter is '\t', embedded labels);