# Split a Table

### Overview

This procedure divides a given table into smaller subtables, each containing at most a specified number of rows. It is useful for handling large datasets that exceed processing or display limits.

{% hint style="warning" %}
The maximum supported row count is 30,000. If no row count is specified, the procedure defaults to using the maximum allowed.
{% endhint %}

### Syntax

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

<details>

<summary><code>split the table into subtables</code></summary>

**What does it do?**

Splits the table into subtables.

**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 table** must be defined.

</details>

<details>

<summary><code>the row count is x</code></summary>

**What does it do?**

Specifies the number of rows per subtable.

**Where does it go?**

Indented under `split the sample table into subtables`.

**Is it required?**

❌ No — This phrase is **optional**.

**Does it require data?**

✅ Yes — Replace **x** with a positive integer representing the number of rows. The default is `30,000`.

</details>

### Examples

#### 1. Split a Table into Subtables Using the Default Row Count

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

```
create a sample table
split the sample table into subtables
```

{% endtab %}

{% tab title="Results" %}

| 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 %} |                   |                  |               |

#### 2. Split a Table into Subtables with 2 Rows Each

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

```
create a sample table
split the sample table into subtables where
    the row count is 2
```

{% endtab %}

{% tab title="Results" %}
**the subtables**

| Name | Number            | Address         | City          |
| ---- | ----------------- | --------------- | ------------- |
| John | +1 (415) 691 9426 | 123 East Street | San Francisco |
| Joe  | +1 (415) 691 1234 | 321 West Street | San Jose      |

| Name          | Number            | Address          | City          |
| ------------- | ----------------- | ---------------- | ------------- |
| 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/split-a-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.