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.

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.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

⛔ No — This phrase does not require input data.

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.

Is it required?

🌟 No — This phrase is optional in the syntax.

Does it require input data?

✅ Yes — A Number value should be specified.

Examples

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

create a sample table
split the sample table into subtables

2. Split a Table into Subtables with 2 Rows Each

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

Last updated

Was this helpful?