Skip to main content Skip to complementary content

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

Working directory

Arguments:  

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:

  • absolute

    Example: c:\data\

  • relative to the Qlik Sense app working directory.

    Example: data\

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

    Example: http://www.qlik.com

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

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!