Why using Directory;?

[#1]

When I load a qvd file the script starts with Directory;

Directory;

LOAD *

FROM

...

What does is stand for?

If I name the file Facts. Can I remove the "Directory"?

Can I write like below? Or is something wrong? Do I have to remove the name " Orders"?

//Orders:

Directory;

LEFT join (Frakt);

LOAD InvoiceNo,

     [In_Line No_],

     [In_Document No_],

     [In_Order No_] as sku_backend

FROM

qvd\sales_invoices_se.qvd

(qvd);

Thanks,

Julia

[MayilVahanan]

HI

You can change the name as your wise instead of directory..No problem.

[#3]

Thanks.

So Directory is used as a name only?

But why do I name a table

Orders:

with :

and Directory is written with ;

?

[swuehl · Accepted solution]

No, it's not for naming / labelling:

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.

[#5]

You can remove the keyword "Directory"

and replace it with table name

<TABLE NAME>:

LOAD

.

.

"Directory" keyword is used for

Statements accessing the computer’s file system, e.g. the load statement, can

be preceded by a directory statement, defining in what directory to search

for the files

Refer "QlikView Reference Manual Page 300/1434