# 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-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Load.htm)
* [Select](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Select.htm)
* [Crosstable](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm)
* [一般資料庫](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/DataSource/generic-databases.htm)