Path as Variable

[#1]

Hi All,

I am using this statement to load data from a QVD.Is there any possibility to store the path:

c:\HummingBird\...............\Complex_QVD's\  in a variable and then call it in below statement?

[#2]

HI Poornima,

  Yes it is possible

use set function & Create Variable

Set Mypath=c:\HummingBird\...............\Complex_QVD's\

Then you can use

Load *

$(Mypath)FACT_WELLNESSMEMBERS.qvd;

Hope this is velpful for you

[v_iyyappan]

Hi

Set the QVD path like this

SET  QvdPath = '..\QVDs\';

Test:

Load

     *

From

$(QvdPath)Test.qvd

Note : you qvw file are in same location.

Regards,

[vikasmahajan]

STORE

DocumentPath() IN VARIABLE

vIKAS

[#5]

SET vFolderSourceFile = 'C:\Hummingbird\CustomerReporting\0_QVD_Generators\Complex_QVDs\';

[Table1]:

LOAD      ........

               .......

FROM  '$(vFolderSourceFile)FACT_WELLNESSMEMBERS.qvd'

[Anonymous]

Yes.

you can write before your load:

Set vPath="c:\HummingBird\...............\Complex_QVD's\ ";

and  then replace:

FROM $(vPath)&yourfilename.qvd (qvd);

I hope to help you.

Regards

[tresesco]

Try like:

SET QVPath=C:\Users\....\QV;

Load * From $(QVPath)\ABC.qvd(qvd);

[Andrea_Ghirardello]

set YourVariableName = 'C:\YourPath\';

Load

     field1,

     field2

from $(YourVariableName)YourQvd.qvd (qvd);