When you're working with destinations in Vizlib Writeback Table, you can use dynamic tags. Dynamic tags allow you to use a dynamic file path and file name for a destination. When a destination uses dynamic tags, it can support more than one app at a time, instead of having to create a new destination for each separate QVD file and app. You can find a full example of setting up a destination using dynamic tags in our article on Loop & Reduce Tasks.
TABLE OF CONTENTS
You can find dynamic tags in the Vizlib Management Console (VMC) when you're setting up a destination (Figure 1). There are two sections where you can use dynamic tags.
- App in Writeback Settings - can be used with all destinations for the Reload Task and Reload App options. For Reload App, the tag has to evaluate to the existing Application_ID and for Reload Task is used, it has to evaluate to the Task_ID.
- Subfolder and Filename in Destination Settings - can only be used with QVD-CSV-TXT destinations).
Figure 1: QVD-CSV-TXT Destination Settings
Adding Dynamic Tags
To add dynamic tags in an App/Reload Task, select one of the Reload Options, then click the icon to open the list. The list contains three items plus available custom properties on apps - Id, Name, and Suffix. If you click an item you'll add the tag. Example with App id and custom property ReloadTaskId (Figure 2).
Figure 2: App Dynamic Tag
When you use dynamic tags in the Subfolder section, you'll need to select a Data Source first, then click the icon to open the list (Figure 3). You can choose one of four options, which in turn have several options. You can add these dynamic tags in
- App - Id, Name, Suffix, and list of available app custom properties held in Qlik Sense.
- App suffix requires that the app name ends with a space, a dash, a space, and the suffix value. E.g. UK when the app is named 'Sales Strategy - UK'.
- Date - Date, Year, Month, Day.
- Time - Timestamp, Hour, Minutes, Seconds.
- User - User, User id, User directory, User role, and list of available user custom properties held in Qlik Sense.
Note: If the custom property is not set or has multiple values on the application/user the dynamic tag will be evaluated as blank. This is also true if the name of the app is not following the naming convention the dynamic tag will be evaluated as blank.
Figure 3: Adding Dynamic Tags
While you can add custom properties as dynamic tags for the User option, you'll only be able to add custom properties which have a single value attached to them. If you try to add a custom property which has multiple values, you'll return an error. You can check for the values attached to a custom property by logging in to the Qlik Management Console (QMC) under Custom Properties in the Values section (Figure 3).
Figure 3: Custom Properties