How to load multiple QVD file dynamically

[#1]

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

[tresesco · Accepted solution]

Probably this?

Load *

From csv_*.qvd;

[#3]

Thanks, it worked for me.

Samir

[Anonymous]

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

[#5]

hi all,

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

[shree909]

Hi u can use

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

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

Thanks

[#7]

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 ?

[shree909]

Hi

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

script(allow database write and execute commands)

This should help you..

[Anonymous]

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

Jonathan