Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!
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...
!
Hi,
You need to use SET instead of LET
ex: SET vPath= \\x\y\z;
Then use $(vPath) in the load statement.
Thanks
Hi,
You need to use SET instead of LET
ex: SET vPath= \\x\y\z;
Then use $(vPath) in the load statement.
Thanks
Try
FROM
[$(vPath)\ABCv2.13 04-18-2014.txt]
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,
correction on first statement ( i missed SET):
SET vPath= C:\Users\jmu\Desktop\pathTest;
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 ....