Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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,
STORE
DocumentPath() IN VARIABLE
vIKAS
SET vFolderSourceFile = 'C:\Hummingbird\CustomerReporting\0_QVD_Generators\Complex_QVDs\';
[Table1]:
LOAD ........
.......
FROM '$(vFolderSourceFile)FACT_WELLNESSMEMBERS.qvd'
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
Try like:
SET QVPath=C:\Users\....\QV;
Load * From $(QVPath)\ABC.qvd(qvd);
set YourVariableName = 'C:\YourPath\';
Load
field1,
field2
from $(YourVariableName)YourQvd.qvd (qvd);