Variable for the path

[#1]

!

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...

!

[Joseph_Musekura · Accepted solution]

Hi,

You need to use SET instead of LET

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

Then use $(vPath) in the load statement.

Thanks

[swuehl]

Try

FROM

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

[Joseph_Musekura]

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,

[Joseph_Musekura]

correction on first statement ( i missed SET):

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

[#6]

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 ....