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.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the table	Table

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.

Does it require input data? ⛔ No — This phrase does not require input data.

Is it required? ✅ Yes — This phrase is required in the syntax.

the row count is

What does it do? Specifies the number of rows per subtable. Must be a positive integer. Defaults to 30,000 if not provided.

Where does it go? This phrase should be indented beneath split the sample table into subtables.

Does it require input data? ✅ Yes — A Number value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

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