Split a Table

Split a large table into smaller subtables.

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.

The maximum supported row count is 30,0000. If no row count is specified, the procedure defaults to using the maximum allowed.

Syntax

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

split the table into subtables

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.

the row count is x

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.

Examples

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

Automation

create a sample table
split the sample table into subtables

Results

Name	Number	Address	City
John	[phone]	123 East Street	San Francisco
Joe	[phone]	321 West Street	San Jose
Jack	[phone]	213 North Street	San Francisco

2. Split a Table into Subtables with 2 Rows Each

Automation

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

Results

the subtables

Name	Number	Address	City
John	[phone]	123 East Street	San Francisco
Joe	[phone]	321 West Street	San Jose

Name	Number	Address	City
Jack	[phone]	213 North Street	San Francisco