# Right

可在 Join 和 Keep 前缀前面使用 right 前缀。

如果用于 join 之前，说明应使用右侧联接。由此生成的表格仅包含原始数据表格的字段值组合，原始数据表格中的链接字段值呈现在第二个表格中。如果用于 keep 之前，说明首先应使第一原始数据表格缩减为其与第二表格间的共同交集，然后才可在 QlikView 中存储此表格。

信息注释是否按同一名称查找字符串函数？请参阅： [Right - 脚本和图表函数](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/Right.htm)

语法：

Right (Join | Keep) [(tablename)](loadstatement |selectstatement )

参数：

表加载参数

| 参数 | 说明 |
| --- | --- |
| tablename | 可以将命名的表格与加载的表格进行比较。 |
| loadstatement 或 selectstatement | LOAD 或 SELECT 语句适用于加载的表格。 |

示例：

Example 1A

| Table1 | - |
| --- | --- |
| A | B |
| 1 | aa |
| 2 | cc |
| 3 | ee |

Example 1B

| Table2 | - |
| --- | --- |
| A | C |
| 1 | xx |
| 4 | yy |

`QVTable:` `SQL SELECT * 
 from table1;` `right join 
 SQL SELECT * from table2;`

Example 1C

| QVTable | - | - |
| --- | --- | --- |
| A | B | C |
| 1 | aa | xx |
| 4 | - | yy |

`QVTab1:` `SQL SELECT  * 
 from Table1;` `QVTab2:` `right keep 
 SQL SELECT * from Table2;`

Example 1D

| QVTab1 | - |
| --- | --- |
| A | B |
| 1 | aa |

Example 1E

| QVTab2 | - |
| --- | --- |
| A | C |
| 1 | xx |
| 4 | yy |

keep 示例中的两个表格通过 A。

` tab1:  ` `LOAD * from 
 file1.csv;` `tab2:` `LOAD  * from 
 file2.csv;` ` .. .. ..  ` `right keep 
 (tab1) LOAD * from file3.csv;`

## 了解详情

* [Join](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Join.htm)
* [Keep](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Keep.htm)
* [Inner](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Inner.htm)
* [Outer](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Outer.htm)
* [Left](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Left.htm)