How to store QVD into path set by variable

[Anonymous]

I'm trying to store a QVD into a file path set by a variable. Here is what I have so far:

In the include file- Set vQVDPath_ExchangeRate= "(private path)\Exchange Rates.qvd";

In the script- $(Include=..\InputFiles\vQVDPath_ExchangeRate);

Then I try to store the QVD like so: STORE [Exchange Rate] INTO vQVDPath_ExchangeRate (qvd);

This doesn't work. What am I doing wrong?

[Miguel_Angel_Baeyens · Accepted solution]

You need to expand the variable, looking like this

STORE [Exchange Rate] INTO [$(vQVDPath_ExchangeRate)] (qvd);

If you want to see the contents of the variable, either debug instead of run from the script editor, and you can set a break point on the SET instrucion or the $(Include=) and see whether the value is properly populated

[sunny_talwar]

May be try this

STORE [Exchange Rate] INTO '$(vQVDPath_ExchangeRate)' (qvd);