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