Generic
The Generic load prefix allows for conversion of entity–attribute–value modeled data (EAV) into a traditional, normalized relational table structure. EAV modeling is alternatively referred to as "generic data modeling" or "open schema".
While it is technically possible to load and analyze EAV modeled data in Qlik, it is often easier to work with an equivalent traditional relational data structure.
Syntax:
Generic( loadstatement | selectstatement )
- For more information about using LOAD statements, see Load.
- For more information about using SELECT statements, see Select.
These topics may help you work with this function:
Topic | Description |
---|---|
Crosstable | The Crosstable load prefix transforms data that is horizontally-oriented into vertically-oriented data. From a purely functional perspective, it performs the opposite transformation to the Generic load prefix, although the prefixes typically serve entirely different use cases. |
Generic databases | EAV structured data models are further described here. |