Skip to main content
Directory

ON THIS PAGE

Directory

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, QlikView will look in the QlikView working directory.

Working directory

Arguments:  

Argument Description
path

A text that can be interpreted as the path to the qvw file.

The path is the path to the file, either:

  • absolute

    Example: c:\data\

  • relative to the QlikView document path.

    Example: data\

  • URL address (HTTP or FTP), pointing to a location on the Internet or an intranet.

    Example: http://www.qlik.com

Example:  

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

See also

 

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com