A generic database is a table in which the field names are stored as field values in one column, while the field values are stored in a second. Generic databases are usually used for attributes of different objects.
Look at the example
On one hand it would be awkward to store the data in a way giving each attribute a column of its own, since many of the attributes are not relevant for a specific object.
On the other hand, it would look messy displaying it in a way that mixed lengths, colors and weights.
If this database is loaded into QlikView using the standard way and display the data in a table it looks like this:
However, if the table is loaded as a generic database, column two and three will be split up into different tables, one for each unique value of the second column:
The syntax for doing this is simple:
Generic SELECT* from GenericTable;
It does not matter whether a LOAD or SELECT statement is used to load the generic database.