topic how to load QVD from variables path in QlikView

how to load QVD from variables path

Thu, 19 Feb 2015 12:27:19 GMT

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.

Re: how to load QVD from variables path

engishfaque — Thu, 19 Feb 2015 16:43:45 GMT

Dear Saikat,

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

Example:

From [Your Data Source Location \*.qvd]

Kind regards,

Ishfaque Ahmed

Re: how to load QVD from variables path

mukesh24 — Thu, 19 Feb 2015 16:55:42 GMT

Hi Saikat,

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

Regards,

Mukesh Chaudhari

Re: how to load QVD from variables path

maxgro — Thu, 19 Feb 2015 19:50:24 GMT

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;

Re: how to load QVD from variables path

Fri, 20 Feb 2015 06:29:16 GMT

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.