> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/rpa-studio/data/datatable/join-data-table.md).

# Join Data Table

The activity combines the rows from two data table with the help of join rules and joins type applied on both data tables. The resulting data table is stored in a variable.

### Input

* **DataTable 1** : [`DataTable Variable`](/getting-started/rpa-studio/variables.md#datatable)![](/files/hZwYNznPyGoqDLsH6pna)

  The first data table used in the join operation.
* **DataTable 2** : [`DataTable Variable`](/getting-started/rpa-studio/variables.md#datatable)![](/files/hZwYNznPyGoqDLsH6pna)\
  The second data table used in the join operation.
* **Join Type** :\
  The type of join operation used in join data table activity.
  * `Inner` - Takes all the rows from DataTable1 and DataTable2, that satisfy the join rule. The rows that do not satisfy the rule are removed from the resulting table.
  * `Left` - Take all rows from DataTable1 and only the rows from DataTable2 which satisfy the join rule. Null values are inserted for the rows from DataTable1 that do not have a match in DataTable2.
  * `Full` - Take all rows from DataTable1 and DataTable2 which does not consider the join rule. Null values are inserted for the rows from both data tables that do not have a match.

### Configure

* **Join Rules**:\
  The operations that applied to join data tables.

![](/files/-MbkMYpJhhybF5F1qzRV)

{% hint style="info" %}
***Information*** :

* The button **`+`** used to create a new join rule on the join rules window. **`x`** button used to remove the join rule from the window. each rule needs the DataTable1 Column, operator, and DataTable2 Column that are used to join the data tables.
* **`Preview`** the button displayed the two input data tables and the resulting data table on the grid below the join rules.
* **`Join Type`** is the type of join used to combine the rows of DataTable1 and DataTable2.
  {% endhint %}

### Output

* **Output** : [`DataTable Variable`](/getting-started/rpa-studio/variables.md#datatable)

  \
  The variable that stores the resulting data table of the join operation.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.visualyze.ai/rpa-studio/data/datatable/join-data-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.