how to load QVD from variables path

[#1]

We have a situation where output of  one QVD file need to load in another QVD file. First QVD file name will update based on year and month so filename could not be hardcoded in 2nd file.

Ex- First QVD file is like Customer.2014.11.

Now, I want to load the 1st file in 2nd file using  filename variables. Let me know if you need more details. Thanks in advance.

[engishfaque]

Dear Saikat,

I would suggest you to use wild card (*) for file name.

Example:

From [Your Data Source Location \*.qvd]

Kind regards,

Ishfaque Ahmed

[mukesh24]

Hi Saikat,

Can u please elaborate actual requirement. u mean to say First QVD data loaded into 2 qvd?

Regards,

Mukesh Chaudhari

[maxgro]

this?

DIRECTORY;

for vYear=2010 to 2012

  for vMonth=1 to 12

  let vMonth=num($(vMonth), '00');

  $(vYear)$(vMonth):

  load $(vYear) as year , $(vMonth) as month, rowno() as id AutoGenerate  10;

  // store a qvd

  STORE $(vYear)$(vMonth) into Customer.$(vYear).$(vMonth).qvd (qvd);

  DROP table $(vYear)$(vMonth);

  // read a qvd

  New:

  load year as newyear, month as newmonth, id as newid from Customer.$(vYear).$(vMonth).qvd (qvd);

  NEXT;

NEXT;

[#5]

Let me explain in detail.

There are total 2 QVD's.

1. Customer.2014.11 Original.qvw

2. Customer.qvw

Customer.qvw gets loaded from Customer.2014.11 Original.qvw . Used code BINARY 'Customer.2014.11.qvw'; to load Customer.qvw file. Every month creates new copy like  Customer.2014.12 Original.qvw, Customer.2015.01 Original.qvw  etc.  Now the issue is every time during refreshing Customer.qvw we need to modify the path of original paths. I need to configure the file name dynamic inside  Customer.qvw so that I dont have to refresh everytime. Let me know if you need any more info.