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 wiht IPDF withIPDF can be used as a basis for creating alternate templates with different behaviors.
...
- In the Manage Tab click on the New or Edit links
- Type the following data:
- Name: the name template
- Description: freeform text to describe the purpose of this app. template
- Name Prefix: These characters will be appended to the front of each each file name created by this script
- Name Suffix: These characters will be appended to the end of each each file name created by this script
- Notes (optional): freeform text notes (optional)
- Load Script: Qlik Sense load script to be executed for each table in the snapshot
Variables used:
| Name | use |
|---|---|
| _dw_conection | |
| _dw_database | |
| _dw_schema_name | |
| _dw_table_name | |
| _dw_qvd_table_name | |
| _dw_renaming_fields_all | |
| _dw_fields_all | |
| _dw_lineage_fields_all | for adding tags to fields in the QVD to identify the source of the field |
Related articles
| Filter by label (Content by label) | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...