Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

elakkians
New Contributor III

Reduce and Distribute to different folder

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 .

1 Solution

Accepted Solutions
elakkians
New Contributor III

Re: Reduce and Distribute to different folder

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.

7 Replies

Re: Reduce and Distribute to different folder

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

Regards,
Prashant Sangle
elakkians
New Contributor III

Re: Reduce and Distribute to different folder

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

sunilkumarqv
Valued Contributor II

Re: Reduce and Distribute to different folder

elakkians
New Contributor III

Re: Reduce and Distribute to different folder

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

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

Employee
Employee

Re: Reduce and Distribute to different folder

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

neetha_p
Honored Contributor

Re: Reduce and Distribute to different folder

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
New Contributor III

Re: Reduce and Distribute to different folder

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.

Community Browser