topic Re: How can i get the field value from variable in script in QlikView

How can i get the field value from variable in script

vidhya91gct — Thu, 18 Jun 2015 10:56:51 GMT

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 — Thu, 18 Jun 2015 15:24:35 GMT

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

swuehl — Thu, 18 Jun 2015 15:30:01 GMT

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

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

Let vdatapath= '\\2\storedata1';

Then

LOAD ...

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

vidhya91gct — Fri, 19 Jun 2015 10:37:44 GMT

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