# Generic

The generic prefix unpacks a tall table, creating one field per attribute value. This is similar to pivoting a table, except that it results in a separate table per field created.

Syntax:

Generic( loadstatement | selectstatement )

Tables loaded through a generic statement are not auto-concatenated.

Example:

`Table1:` `Generic 
 LOAD * INLINE` `[` `Key, Attribute, Value` `Bob, Jan, 100` `Bob, Feb, 200` `Bob, Mar, 300` `Kate, Jan, 400` `Kate, Feb, 500` `Kate, Mar, 600` `];` ` `

**Result:**

This will result in 3 tables:

Table1.Jan:

Example 1

| Key, | Jan |
| --- | --- |
| Bob, | 100 |
| Kate, | 400 |

Table1.Feb:

Example 2

| Key, | Feb |
| --- | --- |
| Bob, | 200 |
| Kate, | 500 |

Table1.Mar:

Example 3

| Key, | Mar |
| --- | --- |
| Bob, | 300 |
| Kate, | 600 |

## Learn more

* [Load](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Load.htm)
* [Select](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Select.htm)
* [Crosstable](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm)
* [Generic databases](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/DataSource/generic-databases.htm)