Create a Combined Table

Creates a combined table from two or more existing tables.

Overview

This procedure creates a combined table from two or more existing tables.

Input Concepts

Concept	Type	Description	Default	Required
first table	table	The first table to be combined.	No default	Either tables or first table and second table are required.
second table	table	The second table to be combined.	No default	Either tables or first table and second table are required.
tables	list of tables	A list of tables to be combined.	No default	Either tables or first table and second table are required.
excluded columns	list of strings	A list of column names to be excluded from the combined table.	No default	No
included columns	dictionary	A dictionary specifying which columns to include from each table. The keys are table names, and the values are lists of column names to include.	No default	No
same columns	list of strings	A list of column names that are the same across all tables and should be combined into a single column in the combined table.	No default	No

Output Concepts

Concept	Description
table	A combined table created from the specified tables, with considerations for excluded and included columns, as well as columns that are the same across tables.

Examples

1. Create a Combined Table From the Tables

create a combined table with
    the tables

2. Create a Combined Table From the First and Second Tables

create a combined table with
    the first table
    the second table
    the excluded columns are "ID", "Timestamp"
    the same columns are "Name", "Email"