It is possible to setup a task to distribute to a sub folder. Depending on the configuration of taks setup you can achive following alternatives:
1. Create a separate sub folder and document for each value in the Loop and reduce field.
2. Create one sub folder contining the documents from the Loop and Reduce field.
3. Create a separate sub folder for each value in the Loop and reduce field containing only one document.
Note that these instructions only include the creation of documents distributed to dynamically created sub folders. It does not go into details about setting permissions.
Permissions are to be set depending on the authorization model used in the QlikView deployment, NTFS or DMS. See Loop and Distribute
on the Qlik Help for details.
In this example following Fields are used:
Distributing to folder (same result with distribution to Server):
A sub folder distribution is specified on the Reduced Document Name,
with a backslash:
3 diffrent results can be achived depending on the setup for Loop and Reduce
and Reducded Document Name
.Option 1 - Create a sub folder on the Loop and Reduce field value
This will create a separate sub folder and document for each value in the Loop and reduce field.Example:
A Sub Folder is created for each value in the Loop and Reduce, Dim1:
This task setup will result in one Sub folder for each value in Field for Loop and Reduce containing the reduced document: \\dc1\share\Front-end\Mount2\ A \A.QVW \\dc1\share\Front-end\Mount2\B\B.QVW\\dc1\share\Front-end\Mount2\C\C.QVWOption 2 - Create a sub folder on a different field value than Loop and Reduce field value
This will create one sub folder contining the documents from the Loop and Reduce field.Example:
Set up a different field for the folder path, Dim3 and the Loop and Reduce to field Dim1:
This task setup will not loop the values in the Dim3 field and therefore created only one folder, in this case X.
The X folder will contain the 3 reduced documents: \\dc1\share\Front-end\Mount2\XA
.qvwOption 3 - Create a sub folder on the Loop and Reduce field value with a different field value for Document
This will create a separate sub folder for each value in the Loop and reduce field containing only one document.Example:
This will result in a Loop of the values for the Folder path, Dim3 and therefor end up with 3 folders, but not looping on the document field Dim1 and therefore end up with only one document, A.qvw: \\dc1\share\Front-end\Mount2\X\A.qvw\\dc1\share\Front-end\Mount2\Y\A.qvw\\dc1\share\Front-end\Mount2\Z\A.qvw
NOTE: When using the '\' in the Reduced Document name to create a sub foler it is important to remove all spaces in the Reduce Document name before running the task. This since Space is not a valid sign in a folder name.