What is the use of keyword 'Directory' here?

[ananyaghosh]

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

;

[sushil353]

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

[danieloberbilli]

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

[maxgro]

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)

[vishsaggi]

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.

[buzzy996]

it helps load multiple files from file system.