# Generic

generic 前缀解压长表格，每个属性值创建一个字段。这跟透视表格类似，只不错它的结果是每个创建的字段产生一个单独的表格。

语法：

Generic( loadstatement | selectstatement )

通过 generic 语句加载的表格不可自动连接。

示例：

`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` `];` ` `

**结果：**

这将生成 3 个表格：

Table1.Jan:

示例 1

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

Table1.Feb:

示例 2

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

Table1.Mar:

示例 3

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

## 了解详情

* [Load](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Load.htm)
* [Select](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Select.htm)
* [Crosstable](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm)
* [通用数据库](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/DataSource/generic-databases.htm)