Page Comparison

...

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)

...

• Name: the dictionary entry
• Description: freeform text description of the lookup table
• To Item: 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

...

1. In 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

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

...