Reduce and Distribute to different folder

[elakkians]

Hi ,

I need to reduce a single application into 3 applications and distribute to 3 folders .

for eg:

i have a application contains data's of 3 country's (INDIA, US , CANADA) . now i need to distribute each country's data into 3 folders. so that the application will have the same name but 3 different data.

could any one help me out with this requirement .

[PrashantSangle]

Hi,

you can reduce it in where clause

try like

India:

Load *

from TableName

where Country='India';

Store India into ../India/app.qvd;

Drop table India;

US:

Load *

from TableName

where Country='US';

Store India into ../US/app.qvd;

Drop table US;

Regards

[elakkians]

i am not looking to store the data i am using publisher to distribute the application .

[sunilkumarqv]

http://www.qlik.com/us/videos/landing-pages/security-video-series/security-video-series-pt5

[elakkians]

this video shows how to distribute to the same folder with different names .

my requirement is to distribute to different folders but same name .

[Bill_Britt]

HI,

You can do this with publisher, but it will require three task to do it. Each task would do the distribution to a different folder

Bill

[Anonymous]

HI,

Maybe Create the new fields(for each value of country) on the data model ,

Next create different tasks in QMC to distribute the files into different folders.

Regards

Neetha

[elakkians · Accepted solution]

here is a way to get this working by using only one Task.

- Manage the Foldernames as a DocumentField in the Data Model

- Reduce by Field Foldername with a Publisher Task. Reduced Document Name is something like :

%DocumentField,Foldername%\%SourceDocumentName% %DocumentField,Foldername%

- Distribute PDF or qvw  to a Folder that contains all Foldernames of the DocumentField as subfolders

That is all.