topic Re: Variable for the path in QlikView

Variable for the path

Fri, 09 May 2014 17:55:28 GMT

For creating the Variable for the path I am getting probelm

For path \\x\y\z\ABCv2.13 04-18-2014.txt

I used Let vPath = \\x\y\z;

LOAD .....

FROM

[vPath\ABCv2.13 04-18-2014.txt]

But it is not working ...

My question is ..

1.It is server path can declare thru variable..

2.Is there any Syntax error in this...

3.For Such files the date varies 04-18-2014 by week ,and also version v2.13 changes ... can I declare them also in variable so that if it changes it picks it automatically...

Re: Variable for the path

Joseph_Musekura — Fri, 09 May 2014 18:01:01 GMT

Hi,

You need to use SET instead of LET

ex: SET vPath= \\x\y\z;

Then use $(vPath) in the load statement.

Thanks

Re: Variable for the path

swuehl — Fri, 09 May 2014 18:01:23 GMT

Try

FROM

[$(vPath)\ABCv2.13 04-18-2014.txt]

Re: Variable for the path

Joseph_Musekura — Fri, 09 May 2014 18:17:03 GMT

As advised I tested this and it is OK

vPath= C:\Users\jmu\Desktop\pathTest;

LOAD Salesman, Year1, Janu, Febr, Marc, Apri

FROM

$(vPath)\crossTable2.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Regards,

Re: Variable for the path

Joseph_Musekura — Fri, 09 May 2014 18:18:09 GMT

correction on first statement ( i missed SET):

SET vPath= C:\Users\jmu\Desktop\pathTest;

Re: Variable for the path

Fri, 09 May 2014 18:26:06 GMT

For Such paths we have files ABCv2.13 04-18-2014.txt...... the date changes 04-18-2014 by week from 04-18-2014 to 04-25-2014.(exactly seven days)

Is there any thing possible by incremental load here to change the date from one week to next week ... Is it possible ....