Join Subtables

Combines multiple subtables into a single table.

Overview

This procedure joins a list of subtables into a single table. This is typically used to reverse the operation Split a Table. If you've used a different procedure to split the original table into subtables, then it is not recommended to use this one to join them.

All the subtables must have the same number of columns and matching column names.

Prerequisite Data

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

Data Name	Data Type
the subtables	List of Tables

Syntax

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

join the subtables into the combined table

What does it do? Joins the list of subtables into a single table.

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.

Examples

1. Join subtables after splitting

Automation

create a sample table
split the sample table into subtables where
    the row count is 1
join the subtables into the combined table

Results

the combined table

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