QS App Templates

Owned by Steffan Holmquist (Deactivated)
Last updated: Feb 10, 2020 by Mark Costa
2 min read

Qlik Sense Application Templates are re-usable load scripts for creating Qlik Sense QVDs from tables identified in the Schema Snapshot.  This is the location of any logic you want to apply during the ETL from source tables to Qlik QVDs.
There is no limit to the number of Templates that can be created, however a typical implementation will have no more than one template per Origin Database.

The Default template that is shipped with IPDF can be used as a basis for creating alternate templates with different behaviors.

Typically, the load script is written in Qlik Sense to leverage syntax checking in the native editor.  Script is then coppied and pasted into the Load Script section of this web form.  When you have finished making your changes to the load script, click on the update link located in the lower right side of the screen.

Note that Qlik script syntax checking is not performed on this IPDF screen.

Manage Tab

Step-by-step guide

  1. In the Manage Tab click on the New or Edit links

  2. Type the following data:

    1. Name: the name template

    2. Description: freeform text to describe the purpose of this app. template

    3. Name Prefix: These characters will be appended to the front of each each file name created by this script

    4. Name Suffix: These characters will be appended to the end of each each file name created by this script

    5. Notes (optional):  freeform text notes (optional)

    6. Load Script: Qlik Sense load script to be executed for each table in the snapshot

Variables used:

Name

use

Name

use

_dw_conection

expands to the connection name as it is found in the snapshot

_dw_database

expands to the database name as it is found in the snapshot

_dw_schema_name

expands to the schema name as it is found in the snapshot

_dw_table_name

expands to the table name as it is found in the snapshot

_dw_qvd_table_name

expands the table name found in the XML header of the QVD as found in the Origin Tables/Views QVD Table Name

_dw_renaming_fields_all

expands the table name found in the XML header of the QVD as found in the Origin Items

_dw_fields_all

these are the original field names from the table found in the schema snapshot

_dw_lineage_fields_all

for adding tags to fields in the QVD to identify the source of the field

Related articles

Filter by label

There are no items with the selected labels at this time.