QlikView Expressor - Creating and Managing In-Memory Lookup Tables

    For situations in which lookup table volumes are relatively small (e.g., <100,000 records), using in-memory Datascript tables for efficiently storing and retrieving values by keys can be as mush as 5 to 10 times faster than using a Lookup Table and Lookup Rule in QlikView Expressor dataflows.  This document describes the implementation of a Datascript Module that supports the creation, persistence, reloading and usage of lookup tables based on an in-memory Datascript table.

     

    Attached to this posting is a .zip file that includes a Datascript module that implements an in-memory lookup table and a document that describes its usage.