How can i get the field value from variable in script

[vidhya91gct]

Hi All,

How can i get the field value from variable in script.

for example:

In excel , i am loading the below format in the column

column name : QVDField

$(vdatapath)abc.qvd

$(vdatapath1)def.qvd

$(vdatapath)xyz.qvd

Let vdatapath=\\1\storedata\;

Let vdatapath=\\2\storedata1;

i would like to expect value format is \\1\storedata\abc.qvd (that mean $(vdatapath)abc.qvd - field value and qvd filename) in script.

Any idea or suggestion ?

[tschullo · Accepted solution]

Are you doing the "Let" before you reference the variable?

[swuehl]

If you are using LET, you need to quote the path:

Let vdatapath= '\\1\storedata\';

or

Let vdatapath= '\\2\storedata1';

Then

LOAD ...

FROM $(vdatapath)abc.qvd (qvd);

[vidhya91gct]

yes.... before I assigned the LET Vsriable.