topic Re: How to load multiple QVD file dynamically in QlikView

How to load multiple QVD file dynamically

Thu, 27 Jan 2011 06:52:10 GMT

Hi,

My requirement is as following:

Getting csv file on daily basis from the server and csv file names are distinguished on date field like csv_27012011, csv_26012011...

Producer.qvw will convert this csv file into QVD file.

Consumer.qvw want to read all available QVD file availble in qvd folder.

How to load multiple QVD files?

How to iterate over QVD files, so that Consumer.qvw can read all available QVD files?

Thanks in advance,

Samir

How to load multiple QVD file dynamically

tresB — Thu, 27 Jan 2011 07:21:11 GMT

Probably this?

Load *

From csv_*.qvd;

How to load multiple QVD file dynamically

Thu, 27 Jan 2011 10:45:08 GMT

Thanks, it worked for me.

Samir

How to load multiple QVD file dynamically

Anonymous — Thu, 21 Jul 2011 05:13:42 GMT

Hi Samir,

Can you show me how did you write the Load statement for multiple QVD's. need help Since I am unable to load multiple QVDs at once. Its stucking while reloading after two or three QVD.

Best,

Skumar

Re: How to load multiple QVD file dynamically

Mon, 03 Jun 2013 15:29:01 GMT

hi all,

can anyone tell me how to copy all files from particular location to another location?

Re: How to load multiple QVD file dynamically

shree909 — Mon, 03 Jun 2013 16:23:56 GMT

Hi u can use

EXECUTE cmd.exe /c move "source directory" "destination directory".

so all the files are moved to the destination directory..

Thanks

Re: How to load multiple QVD file dynamically

Tue, 04 Jun 2013 08:00:28 GMT

shree909,

It works fine.but while executing first time,it shows some message like " need to give system access" .when we execute second time it does not show this error.now what i want is that how we can avoid not to get this error message at very first time ?

Re: How to load multiple QVD file dynamically

shree909 — Tue, 04 Jun 2013 13:40:57 GMT

goto the Settings ---> user Preferences---> properties-- --> security tab and check the second option

script(allow database write and execute commands)

This should help you..

Re: How to load multiple QVD file dynamically

Anonymous — Tue, 04 Jun 2013 13:55:29 GMT

To limit to a specific document you can check the "Can execute external programs" tickbox on the Edit Script dialogue's Settings tab

Jonathan