Combine Tables

Combines multiple tables into a single table based on specified criteria.

Overview

This procedure combines multiple tables and merges them into a single table based on specified criteria. This is useful when you have related data spread across multiple sources and want to bring it all together for easier analysis or reporting.

Input Concepts

Concept	Type	Description	Default	Required
tables	list of tables	The tables to be combined.	No default	Yes
excluded columns	list of strings	Columns to be excluded from the final table.	No default	No
included columns	dictionary	Specifies which columns to include from each table. The dictionary keys are table identifiers, and the values are lists of column names to include.	No default	No
same columns	list of strings	Columns that are considered the same across tables and can be merged.	No default	No

Output Concepts

Concept	Description
table	A single table that combines the input tables according to the specified criteria.

Examples

1. Combine the Tables

combine the tables

2. Combine the Tables with Optional Arguments

combine the tables
    the excluded columns are "ID", "Timestamp"
    the same columns are "Name", "Email"