Page Comparison

Use this feature to create lookup tables.

The high level sequence for creation is:

A. Define a name (ie 'header') for the lookup table (Manage tab)

B. Populate the lookup table with to/from values (Import Data tab or Dictionary Lookup Values)

C. Associate the lookup table with a particular dictionary (Associate Dictionary Entries tab)

D. Check the list of associations that have been made with the option to selectively delete them (Linked Dictionary Entries tab)

Manage Tab

Step-by-step guide

...

• Name: the dictionary entry
• Description: freeform text description of the lookup table
• To Item: is the name of the source field for the contents that are being mapped this is the field name if you use the lookup table in a Qlik Sense mapping load.  When you applymap this name to a field, the field will be renamed as the "To Item" name
• Default Value (optional): is a default value for values that are not mapped in the Dictionary Lookup Values
• Governance: associated Governance item (future use)
• Tags (optional): any metadata tags for easy searching
• Notes (optional):  freeform text for notes

...

1. Click on the template link
2. open the MS Excel workbook and find two sheets
   1. Sheet named "Lookup" has the same fields as described in the definition screen above - you can import multiple entries into the dictionary
   2. Sheet named "LookupValues" has the same fields described in Dictionary Lookup Values in this help document
3. Make any entries and save the MS Excel workbook
4. From the Import Data Tab, browse for the file you updated and upload it
5. The processing messages is followed by a success message

...

Linked Dictionary Entries Tab

Origin Source Types are captured during the Schema Snapshot > Origin Connections > Get Connections Tab process.
They are used to identify the type of the Origin Connections (e.g. folder, ODBC, OLEDB).

There are no IPDF default valuesUse this feature to list all Lookup Tables that have been associated with Dictionary Entries and selectively delete unwanted associations.

Image Added

Associate Dictionary Entries Tab

Use this feature to associate a Dictionary Lookup table that you have created to a specific Dictionary Entry.

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 of the Origin Source Type
   2. Description: free text description
   3. Governance (optional): associated Governance item
   4. Notes (optional):  free text optional notes

Image Removed

Associate Dictionary Entries Tab

Origin Source Types are captured during the Schema Snapshot > Origin Connections > Get Connections Tab process.
They are used to identify the type of the Origin Connections (e.g. folder, ODBC, OLEDB).

There are no IPDF default values.

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 of the Origin Source Type
   2. Description: free text description
   3. Governance (optional): associated Governance item
   4. Notes (optional):  free text optional notes

...

1. the left table, choose a Dictionary Lookup Name by selecting the check box for the name you want to associate
2. On the right side, select the Dictionary you want from the drop down list (ex "CDW")
3. Select the check box for the Dictionary Entries that should be associated with the Lookup Table
4. Click the Image Added button to make the association

Image Added

Using the Code Snippet to help you with a Mapping Load in Qlik Sense

• On the Manage tab, click on the Image Added button
• A .txt file is dropped in your browser's default download folder
• open codesnipet.txt 
• find code that you can copy and paste into the load script of a Qlik Sense application

example:

Image Added

Related articles

...