Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

What is the use of keyword 'Directory' here?

Directory;
ORG_TABLE:
LOAD * INLINE [
    Category, Classification, Name
    Metrics, Property Leasing Status, Cap Rate Implied
    Metrics, Property Leasing Status, Discount Rate
    Metrics, DCF Assumptions, Terminal Cap Rate
    Metrics, DCF Assumptions, NRA Expiring Yrs 1-3
    Metrics, Value Conclusions, Average Market Rent Growth
    Metrics, Value Conclusions, Average Contract Rent PSF
    Metrics, Value Conclusions, Value Per SQ Ft
    Dimension, Property, Property Type
    Dimension, Property, Property Subtype
    Dimension, Location, Country
    Dimension, Location, Region
]
;

;

Tags (1)
5 Replies
Highlighted
Master II
Master II

Re: What is the use of keyword 'Directory' here?

hi,

you can define a specific path followed by Directory and all your files will be saved to that path.

Example:

Directory c:\Programfile\data;

The directory defined through this statement is used by subsequent Load statements, until a new directory statement is made.

A directory statement is generated automatically if Relative Paths is enabled in the Edit Script dialog.

HTH

Sushil

Highlighted
Specialist II
Specialist II

Re: What is the use of keyword 'Directory' here?

no use at all  - there could be a preceeding path defined - but there isnt

Highlighted
MVP
MVP

Re: What is the use of keyword 'Directory' here?

directory is useful for a load or a store (from file system)

but you don't have any load or store (only an inline load)

Highlighted
Champion III
Champion III

Re: What is the use of keyword 'Directory' here?

Hi Sandip,

Just FYI.

From Qlikview Help:

Directory

The Load statement can be preceded by a directory statement, defining what directory to look for the files in.

directory path

where:

path is a text that can be interpreted as the path to the file, either absolute, or relative to the .qvw file.

Example:

Directory c:\userfiles\data;

The directory defined through this statement is used by subsequent Load statements, until a new directory statement is made.

A directory statement is generated automatically if Relative Paths is enabled in the Edit Script dialog.

Regards,

V.

Highlighted
Master II
Master II

Re: What is the use of keyword 'Directory' here?

it helps load multiple files from file system.