topic Re: Why using Directory;? in QlikView

Why using Directory;?

Fri, 28 Sep 2012 13:15:08 GMT

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 — Fri, 28 Sep 2012 13:18:00 GMT

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

Fri, 28 Sep 2012 13:24:40 GMT

Thanks.

So Directory is used as a name only?

But why do I name a table

Orders:

with :

and Directory is written with ;

swuehl — Fri, 28 Sep 2012 13:28:30 GMT

No, it's not for naming / labelling:

Fri, 28 Sep 2012 13:29:25 GMT

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