# Join Subtables

### Overview

This procedure joins a list of subtables into a single table. This is typically used to reverse the operation **Split a Table**. If you've used a different procedure to split the original table into subtables, then it is *not* recommended to use this one to join them.

{% hint style="warning" %}
All the subtables must have the same number of columns and matching column names.
{% endhint %}

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>join the subtables into the combined table</code></summary>

**What does it do?**

Joins the list of subtables into a single table.

**Where does it go?**

This phrase should be written on a **new line**.

**Is it required?**

✅ Yes — This phrase is **required**.

**Does it require data?**

✅ Yes — A reference to **the subtables** must be provided.

</details>

### Examples

#### 1. Join subtables after splitting

{% tabs %}
{% tab title="Automation" %}

```
create a sample table
split the sample table into subtables where
    the row count is 1
join the subtables into the combined table
```

{% endtab %}

{% tab title="Results" %}
**the combined table**

| Name          | Number            | Address          | City          |
| ------------- | ----------------- | ---------------- | ------------- |
| John          | +1 (415) 691 9426 | 123 East Street  | San Francisco |
| Joe           | +1 (415) 691 1234 | 321 West Street  | San Jose      |
| Jack          | +1 (415) 691 4595 | 213 North Street | San Francisco |
| {% endtab %}  |                   |                  |               |
| {% endtabs %} |                   |                  |               |


---

# Agent Instructions: 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.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/join-subtables.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.
