Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently having the following problem. I have a QVW application where I use the loop and reduce functionality to split it up into 20 different QVW's... each file containing the data for one country.
Now I have a folder structure with seperate folders for every country, so the idea is that the QVW containing Germany's data ends up in the folder "Germany" and the one containing data from Francen in the folder France etc
Anyone knows how this can be done in a single task ? ... I think it was possible in earlier versions, but can't seem to find a working solution now.
Thanks for the help.
Regards,
Jan
Can you do something like %DocumentField,F1%\%SourceDocumentName%_%DocumentField,F1% in the reduced document name?
Take the folder name from a field in the document and use it in the loop & reduce settings.
I have the same problem. And it does not help. All files saves into one folder with name "%DocumentField,F1%". How i can save files into dynamic folders named as values of field?
I'm storing all files in same folder, but change the file name depending on the variables Year and j (counter for week)
Like this:
SET FileNamePer= '$(vFolderMainPath)$(vFolderSourcePerData)$(Year)_$(j).qvd';
Store PerData into $(FileNamePer) (qvd);
Should work similar if you'd like to store it into a different Folder
I want to do this without changes in load script and without reloading of data. Such as QV Publisher reducing. Is there another way?
It can be done.
You just to have your reduction on field in place and it works.
And the result will be
Each contains a reduced qvw.
Hi,
If the trick with the file name doesn't make it, you could call a supporting task chained with your distributing task. This ST would make a call to an external program (like a .bat) that would move all the QVWs into the right folder based on the QVW file name.
Regards,
Loic
Thanks! It seems good. But i have no results doing all such way. Which version of QV you are using? I am using QV 11.
You should have publisher to do so!
Yes, of course. I try to do it in QV Publisher.